Re: HELP! Data needed out of pgsql!
| От | Lester |
|---|---|
| Тема | Re: HELP! Data needed out of pgsql! |
| Дата | |
| Msg-id | 8A7A4478-D467-43CF-8366-D9B1F7085EB3@mac.com обсуждение исходный текст |
| Ответ на | Re: HELP! Data needed out of pgsql! (John DeSoi <desoi@pgedit.com>) |
| Список | 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 по дате отправления: