Try the same command from the folder in which the data is stored.
What is the storage folder when you created the database using initdb
command?
Also, place the path to pgsql commands in the .bash or .bash_profile
file..
See if that works.
Hari
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Neil
Sent: Monday, December 06, 2004 10:13 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] message type 0x44
Hi
I have been trawling the archives but have not what I am after with
regards to the message below.
from pg_dump -d ourdb > quick-backup-dec7.db
I eventuate with the following
$ pg_dump: message type 0x44 arrived from server while idle
$ pg_dump: dumpClasses(): SQL command failed
$pg_dump: Error message from server: server closed the connection
unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
$ pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
Not quite sure what it all means, DB seems to be functioning OK but I am
not convinced I am dumping all the I am expecting to.
Any pointers/clues would be great
The PSQL Version 7.2, yes, old I know, just not feasible to upgrade just
yet, inherited this and have a bit to learn. Also there is no syslog
logging at present, all goes to console at the moment, however there
seems
to be no log messages with this.
TIA
Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match
