On Fri, Jul 16, 2010 at 10:14 PM, Scott Marlowe
<scott.marlowe@gmail.com> wrote:
On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael <
bluestar43@gmail.com> wrote:
> Scott...
>
> On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe <
scott.marlowe@gmail.com>
> wrote:
>>
>> So what does
>>
>> sudo locate postgresql.conf
>>
>> say?
>
> That I am irredeemably lazy as an admin? :)
True enough, if you can *remember* how you implemented your efficiency. :D
>
> /usr/share/pgsql/postgresql.conf.sample
> /var/lib/pgsql/data/postgresql.conf
> /home/archives/db/postgresql.conf
> /home/postgres/data/postgresql.conf
>
> The first line is the --datadir as reported by pg_configure --configure
> The second line is the 7.4 data dir according to its PG_VERSION
> The third line was a directory backup I made when I upgraded to 8.1
> The fourth line is the most recently updated database according to the time
> stamps. (three days ago)
So, what does PG_VERSION in each of the above directories have to say?
7.4, which is unfortunately consistent with the idea of having done all the backup and restore work while cd'd to the now deleted binaries directory when I installed 8.1, although I no longer remember for sure. At the very least, it's the only explanation that makes sense to me, because pg_ctl --version pretty clearly shows 8.1.11 *headscratch*