Re: HELP! Data needed out of pgsql!

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.
>
>
>
>