What is the postgres database running on? Can't you just go to that machine
and pg_dump?
If not then you could try installing cygwin (www.cygwin.com). This
will give you a unix like api and bash shell in windows. The default install
also has a binary version of postgresql including tools such as pg_dump. If
you are wanting the server running on the Windows box you will also need to
download & install cygipc (see the FAQ-MSWIN on the postgresql site. There's
also stuff on techdocs.postgresql.org), when you have ipc-daemon running you
could then initdb.
There is also a pgsql-cygwin list.
- Stuart
> -----Original Message-----
> From: pmiranda@vm.com.br [SMTP:pmiranda@vm.com.br]
> Sent: Friday, September 07, 2001 12:12 AM
> To: pgsql-admin@postgresql.org
> Subject: pg_dump & windows (what a mess...!)
>
> Hi,
>
> I think I'm closer than yesterday to solving my troubles, but still need
> some help (remember I couldn't start pg_dump from DOS' command line? well,
> I still can't....).
>
> As I couldn't what I was trying to, I tried to connect to Postgres via
> psql
> (from the command line) and I got the message:
>
> connectDB() -- connect() failed: No such file or directory
> Is the postmaster running at 'localhost' and accepting connections on Unix
> socket '5432'?
>
> I figured that, although through Windows clients everything works fine,
> maybe from the command line it's not recognizing where Postgres is. Maybe,
> I missed some configuration parameter or something else (TCP/IP
> perhaps....
> what's pg_hba.conf for? How can I change it?)
>
> Can anyone of you, please, give me some advice? I'm getting crazy! My boss
> will eat my liver, if I don't have this thing fixed right away!!!!
>
> Thanks in advance, for your patience.
>
>
> Regards from Brazil
>
> Paulo
>
> A last question: Is there anybody in this crazy world as innocent as
> myself
> using Postgres & Windows?
>