Re: HELP! Data needed out of pgsql! - Mailing list pgsql-novice

From Lester
Subject Re: HELP! Data needed out of pgsql!
Date
Msg-id 8A7A4478-D467-43CF-8366-D9B1F7085EB3@mac.com
Whole thread Raw
In response to Re: HELP! Data needed out of pgsql!  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
Thanks!

Just to provide more info, this is what I'm getting when I start up the software..

"Unable to connect to server: Connection refused
Is the server running on host "localhost" and accepting TCP/IP CONNECTIONS ON PORT 7147?

Connection data: host=localhost  port=7147 user=mdp  password='mdp' dbname=mdp

Thanks all!

Lester




On Aug 20, 2009, at 8:09 AM, John DeSoi wrote:

Lester,

The docs to pg_dump are here:

http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html

The above documentation has lots of examples at the end. You probably want something like:

pg_dump -U db_user_name db_name > ~/Desktop/db_name.sql


P.S. You need to use "reply all" so your response goes back to the list.


On Aug 20, 2009, at 8:58 AM, Lester wrote:

Hi all,

I have the password and I was able to use the pgadmin.conf to open that file but I don't know how to use pgdump to open the database.   I'm a newb as it concerns working with terminal.  This is for a Mac BTW.


Thanks for your help so far!

Lester



John DeSoi, Ph.D.





pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: HELP! Data needed out of pgsql!
Next
From: David Saracini
Date:
Subject: pg_dump