Thread: pg_dumpall

pg_dumpall

From
Zlatko Matić
Date:
How to start pg_dumpall ?

Re: pg_dumpall

From
Sean Davis
Date:
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 ?

Re: pg_dumpall

From
"Zlatko Matic"
Date:
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


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


Re: pg_dumpall

From
Zlatko Matić
Date:
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


Re: pg_dumpall

From
rod@cgvec.ie
Date:
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.



Re: pg_dumpall

From
"Zlatko Matic"
Date:
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


> 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