     Hi!

   I use postgres6.1. Before install new version I do not make dump_all, but
I move /usr/local/pgsql to /usr/local/pgsql_bk. After that I successfuly
install new version to /usr/local/pgsql. But now I need some data from old
postgres. I try to do this:
% kill postmaster_id
% mv /usr/local/pgsql /usr/local/pgsql-7.4
% mv /usr/local/pgsql_bk /usr/local/pgsql
% su -l pgsql -c 'exec
/usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data -S -o -F -d 3 >&
/usr/local/pgsql/errlog' &
% ps axu | grep postmaster  show me postmaster process running:
postgres 14442  ??  Is     0:00.00
 /usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data -S -o -F -d 3
(postgres)

I try to exec pg_dumpall as postgres user:
./pg_dumpall
Connection to database 'template1' failed.
PQexec() -- Request was sent to backend, but backend closed the channel
before r
esponding.  This probably means the backend terminated abnormally before or
whil
e processing the request.
......

I try to connect as postgres user:
% /usr/local/pgsql/bin/psql
Connection to database 'postgres' failed.
FATAL 1:Database postgres does not exist in pg_database


% ls -al /usr/local/pgsql/data/base
drwxr-xr-x   2 postgres  postgres   1024 Apr  2  2000 postgres
drwx------   2 postgres  postgres   1024 Apr  1  2000 template1
[ .. some other bases .. ]


Could someone help me? I need to get dump from old DB.

Thanks.


Thu, 4 Dec 2003 12:56:52 +0600
"Roman" <pgsql@softava.com>
Getting dump from old version