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