Moving a PostgreSQL database from one server to another

Rodolfo J. Paiz rpaiz at simpaticus.com
Fri Jan 14 15:26:36 UTC 2005


On Thu, 2005-01-13 at 21:21 -0500, Tim Brier wrote:
> You have to have the database running to use pg_dump.
> 
> To dump the databse: pg_dump name_of_database > file_to_save_to
> 

Thanks for the instructions, Tim. It turns out that I *am* doing this
properly, but I still get no output and the pg_dump command fails
silently. I'm fairly stumped!

Furthermore, /var/log/pgsql is still zero bytes... completely empty.
Maybe I could more easily solve the problem if this thing were logging
something... <smile> Why would logging be either off or not working?
Anything I can check or fix?

Cheers,

-- 
Rodolfo J. Paiz <rpaiz at simpaticus.com>




More information about the users mailing list