So, what happens if you do this as the postgres user:
ls -l /var/lib/postgresql/8.0/main/pg_xlog/
I'm going to guess the output indicates you have a directory inside pg_xlog
called pg_xlog_orig.
You probably just need to cd /opt/postgres/logs/wal/pg_xlog_orig as the
postgres user and 'mv * .. ; cd .. ; rmdir pg_xlog_orig' to resolve your
problem.
On Tue, 8 Nov 2005, Joost Kraaijeveld wrote:
As postgres
cd /var/lib/postgres/8.0/main
mv pg_xlog/ pg_xlog_orig
mkdir /opt/postgres/logs/wal
ln -s /opt/postgres/logs/wal pg_xlog
cp -r pg_xlog_orig/ pg_xlog
As root:
/etc/init.d/postgresql-8.0 start
What did I do wrong, and even more important, what should I do?
TIA
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
