On 02/04/2007 19:51, Erick Papadakis wrote:
How can I find the path for pg_dump? You mean on Windows or on Linux?
I am unable to make the "dump" or SQL backup from my Windows machine
to begin with!
On my laptop (WinXP) it's in c:\program files\postgresql\8.2\bin. I've
added this to my system PATH so that I don't have to type it every time....
postgres=# pg_dump MYDB > d:\mydb.sql
It's a command-line program: you don't run it from within psql, but
directly at the shell prompt. For example, on my machine:
C:\Documents and Settings\rod>psql dbname > dumpfile.sql
You might have to specify the database user as which to connect, using
the -U option - see the docs for all options.
The manual on pgsql website about pg_dump gives very little info about
where to execute the command.
The examples in the docs all begin with the shell prompt '$'.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
---------------------------------------------------------------
