Moved postgres, now won't start - Mailing list pgsql-general

From Madison Kelly
Subject Moved postgres, now won't start
Date
Msg-id 469BB0ED.6000706@alteeve.com
Whole thread Raw
Responses Re: Moved postgres, now won't start  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Moved postgres, now won't start  (Zoltan Boszormenyi <zb@cybertec.at>)
List pgsql-general
Hi all,

   I've created a small 2-node (Debian Etch, PgSQL8.1) cluster using a
(shared) DRBD8 partition formatted as ext3 running in Primary/Secondary
mode.

   I shut down postgresql-8.1, moved '/etc/postgresql' and
'/etc/postgres-commin' to '/ha/etc' (where '/ha' is the DRBD partitions
mount point). Then I created symlinks to the directories under '/ha' and
then restarted PostgreSQL. Everything *seemed* okay, until I tried to
connect to a database (ie: 'template1' as 'postgres'). Then I get the error:

$ psql template1
psql: FATAL:  could not open file "global/pg_database": No such file or
directory

   When I tried connecting to another DB as a user with a (md5) password
it recognizes if the password is right or not. Also, the file:

# cat /var/lib/postgresql/8.1/main/global/pg_database
"postgres" 10793 1663 499 499
"template1" 1 1663 499 499
"template0" 10792 1663 499 499

   Exists, and is readable as you can see.

   Any idea what's wrong? Does it not like that '/var/lib/postgres ->
'/ha/var/lib/postgres'?

   Thanks!

Madison

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: pg_dump vs schemas
Next
From: Tom Lane
Date:
Subject: Re: Moved postgres, now won't start