From: | Tore Halset <halset(at)pvv(dot)ntnu(dot)no> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_xlog symlink |
Date: | 2008-02-15 09:17:59 |
Message-ID: | 6E4C15E7-E855-4FEE-908A-21C1F4BFF26C@pvv.ntnu.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello.
I have just moved our database from one server to another using warm
standby. It worked very well.
The setup: PostgreSQL 8.2.5 on Ubuntu. One partition for OS, one for
backup including wal archiving, one for base and one for pg_xlog. It
is set up to archive wals to /backup/masterhostname/wal
There is something strange in the pg_xlog directory of our new master.
%:/usr/local/postgresql-8.2.5/data/pg_xlog# ls -l
total 49220
-rw------- 1 postgres postgres 257 2008-02-15 00:35
000000010000003A00000046.00004D60.backup
-rw------- 1 postgres postgres 16777216 2008-02-15 10:04
000000010000003A0000006C
-rw------- 1 postgres postgres 16777216 2008-02-15 10:04
000000010000003A0000006D
lrwxrwxrwx 1 postgres postgres 45 2008-02-14 21:56
000000010000003A0000006E -> /backup/oldmasterhostname/wal/
000000010000003A0000003B
-rw------- 1 postgres postgres 16777216 2008-02-15 10:08
000000010000003A0000006F
drwx------ 2 postgres root 4096 2008-02-15 10:08 archive_status
As you see, one of the wal files is a symlink to a file on the backup
partition. I would like all the wal files to exist on the pg_xlog for
performance and clarity. Can I safely fix this situation without
restarting the database? Why did not PostgreSQL fix this automatically?
Regards,
- Tore.
From | Date | Subject | |
---|---|---|---|
Next Message | Vikram Vincent | 2008-02-15 10:28:36 | How to re-own db cluster |
Previous Message | libra dba | 2008-02-14 22:41:18 | Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? |