On Fri, Jul 16, 2010 at 10:14 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
True enough, if you can *remember* how you implemented your efficiency. :D
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*
On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael <bluestar43@xxxxxxxxx> wrote:Lazy isn't always bad. Sometimes it makes you an efficiency expert.
> Scott...
>
> On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx>
> 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
So, what does PG_VERSION in each of the above directories have to say?
>
> /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)
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*