Обсуждение: pg_dumpall
How to start 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 ?
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. > >
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
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.
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