pg_dumpall
See:
http://www.postgresql.org/docs/8.0/static/app-pg-dumpall.html
If you need more specifics, you will probably need to give more
specifics like OS and version.
Sean
On Jun 16, 2005, at 5:16 AM, Zlatko Matić wrote:
Show quoted text
How to start pg_dumpall ?
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
Ok. but I have a problem. When i double-click, a black window appears,
prompting for password. But I can't input anything! Cursor is just
blinking. I'm typing and nothing apears. If I click enter, pg_dumpall
just closes... Postgres 8.02 is installed on Windows XP...
Don't double-click on the application....open a console window first by
going to Start -> All programs -> Accessiories -> Command prompt,
then run it by typing (and substituing as necessary for the bits in <...>):
c:\<path to installation>\bin\pg_dumpall <options>
I'd recommend including the option -U <Postgres user> which makes
the connection as that user - otherwise it tries to connect as the
Windows user under which you're current logged into the machine,
and if there is no corresponding user in Postgres the connection will
fail.
--Ray.
Import Notes
Reply to msg id not found: 001301c57256$fb8134f0$17748353@zlatkovyfkpgz6 | Resolved by subject fallback
Done. Thanks.
----- Original Message -----
From: <rod@cgvec.ie>
To: <zlatko.matic1@sb.t-com.hr>; <pgsql-general@postgresql.org>
Sent: Thursday, June 16, 2005 3:06 PM
Subject: Re: [GENERAL] pg_dumpall
Show quoted text
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
Ok. but I have a problem. When i double-click, a black window appears,
prompting for password. But I can't input anything! Cursor is just
blinking. I'm typing and nothing apears. If I click enter, pg_dumpall
just closes... Postgres 8.02 is installed on Windows XP...Don't double-click on the application....open a console window first by
going to Start -> All programs -> Accessiories -> Command prompt,
then run it by typing (and substituing as necessary for the bits in
<...>):c:\<path to installation>\bin\pg_dumpall <options>
I'd recommend including the option -U <Postgres user> which makes
the connection as that user - otherwise it tries to connect as the
Windows user under which you're current logged into the machine,
and if there is no corresponding user in Postgres the connection will
fail.--Ray.
Done. Thanks.
----- Original Message -----
From: "Sean Davis" <sdavis2@mail.nih.gov>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, June 16, 2005 11:51 AM
Subject: Re: [GENERAL] pg_dumpall
See:
http://www.postgresql.org/docs/8.0/static/app-pg-dumpall.html
If you need more specifics, you will probably need to give more
specifics like OS and version.
Sean
On Jun 16, 2005, at 5:16 AM, Zlatko Matić wrote:
How to start pg_dumpall ?
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Ok.
----- Original Message -----
From: <rod@cgvec.ie>
To: <zlatko.matic1@sb.t-com.hr>; <pgsql-general@postgresql.org>
Sent: Thursday, June 16, 2005 3:06 PM
Subject: Re: [GENERAL] pg_dumpall
Show quoted text
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
Ok. but I have a problem. When i double-click, a black window appears,
prompting for password. But I can't input anything! Cursor is just
blinking. I'm typing and nothing apears. If I click enter, pg_dumpall
just closes... Postgres 8.02 is installed on Windows XP...Don't double-click on the application....open a console window first by
going to Start -> All programs -> Accessiories -> Command prompt,
then run it by typing (and substituing as necessary for the bits in
<...>):c:\<path to installation>\bin\pg_dumpall <options>
I'd recommend including the option -U <Postgres user> which makes
the connection as that user - otherwise it tries to connect as the
Windows user under which you're current logged into the machine,
and if there is no corresponding user in Postgres the connection will
fail.--Ray.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org