Re: [pgadmin-support] get the copy of a schema
Hi Ray, I installed pg_dump.exe.It is installed in the c:\pgsql\.And i have set the pg bin path as c:\pgsql\bin in pgAdmin.I tried with setting path as c:\pgsql\bin\pg_dump.exe. It gives an Error: PostgresSQL bin path specified is not valid or does not contain a postgres SQl pg_dump executable. However the backup tool is not active. I have tried Another option from the command line. I tried this from c:\pgsql\bin 1. pg_dump -h 192.678.1.67 –p 5436 –U postgres unique_manage >data.sql The Error I am getting is Pg_dump: SQL command failed Pg_dump:Error Message from server:Error:unrecognized configuration parameter “synchronize_seqscans” Pg_dump :The command was:SET synchronize_seqscans TO off Tried as a different user.While trying this,I changed the owner name of the database in the PGADmin. 2. pg_dump -h 192.678.1.67 –p 5436 –U dbuser unique_manage >data.sql I got the same error Where am i goin wrong... Thanks Vani Raymond O'Donnell wrote: > > On 24/11/2009 18:53, vani shree wrote: >> Hi Ray, >> Please see this file if the previous document is not opening. > > Vani, *please* reply to the list, not just to me. > > Also, it's much better if you just type the errors directly into the > email rather than attaching a Word document, as it means that your > problem is searchable in the archives. > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support > > -- View this message in context: http://old.nabble.com/get-the-copy-of-a-schema-tp26421440p26513612.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] get the copy of a schema
On 25/11/2009 14:30, vaniShree wrote: > I installed pg_dump.exe.It is installed in the c:\pgsql\.And i have set the > pg bin path as c:\pgsql\bin in pgAdmin.I tried with setting path as > c:\pgsql\bin\pg_dump.exe. Hi Vani, You don't need to include pg_dump itself, just the directory path. For example, my pg_dump.exe is here - C:\Program Files\PostgreSQL\8.4\bin\pg_dump.exe and so I have set the PG bin path as: C:\Program Files\PostgreSQL\8.4\bin > It gives an > Error: PostgresSQL bin path specified is not valid or does not contain a > postgres SQl pg_dump executable. Hmmm... Are you sure that pg_dump is where you're saying it is, in c:\pgsql\bin? You said above that it's in c:\pgsql. > I have tried Another option from the command line. > I tried this from c:\pgsql\bin > 1. pg_dump -h 192.678.1.67 –p 5436 –U postgres unique_manage >data.sql > The Error I am getting is > Pg_dump: SQL command failed >Pg_dump:Error Message from server:Error:unrecognized configuration > parameter “synchronize_seqscans” > Pg_dump :The command was:SET synchronize_seqscans TO off I'm afraid I don't know what that means. What version of pg_dump do you have, and what version of the PostgreSQL server? - For pg_dump, execute: pg_dump --version And for the server, connect to it with psql and execute: select version(); I'm wondering if there's a version mismatch. I'm away for a few days from this evening, so hopefully others will be able to help you. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] get the copy of a schema
On 25/11/2009 14:30, vaniShree wrote: > Pg_dump: SQL command failed >Pg_dump:Error Message from server:Error:unrecognized configuration > parameter “synchronize_seqscans” > Pg_dump :The command was:SET synchronize_seqscans TO off On this one, it may also be worth posting to the pgsql-general mailing list, as this probably isn't a pgAdmin problem. You'll have a wider audience there too. If you do, include as much information as you can - server and client versions, platforms, etc etc. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] get the copy of a schema
Hi , The Pg_dump is installed in c:\pgsql\bin.And I tried with Setting pgbin path as c:\pgsql\bin. It dint work. The version of the pg_dump is c:\pgsql\bin>pg_dump --version pg_dump 8.4.1 I tried the psql select version(); i got this "EnterpriseDB 8.3.0.106 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.5 (mingw-vista special r3)" -Vani Raymond O'Donnell wrote: > > On 25/11/2009 14:30, vaniShree wrote: > >> I installed pg_dump.exe.It is installed in the c:\pgsql\.And i have set >> the >> pg bin path as c:\pgsql\bin in pgAdmin.I tried with setting path as >> c:\pgsql\bin\pg_dump.exe. > > Hi Vani, > > You don't need to include pg_dump itself, just the directory path. For > example, my pg_dump.exe is here - > > C:\Program Files\PostgreSQL\8.4\bin\pg_dump.exe > > and so I have set the PG bin path as: > > C:\Program Files\PostgreSQL\8.4\bin > >> It gives an >> Error: PostgresSQL bin path specified is not valid or does not contain a >> postgres SQl pg_dump executable. > > Hmmm... Are you sure that pg_dump is where you're saying it is, in > c:\pgsql\bin? You said above that it's in c:\pgsql. > >> I have tried Another option from the command line. >> I tried this from c:\pgsql\bin >> 1. pg_dump -h 192.678.1.67 –p 5436 –U postgres unique_manage >> >data.sql >> The Error I am getting is >> Pg_dump: SQL command failed >>Pg_dump:Error Message from server:Error:unrecognized configuration >> parameter “synchronize_seqscans” >> Pg_dump :The command was:SET synchronize_seqscans TO off > > I'm afraid I don't know what that means. What version of pg_dump do you > have, and what version of the PostgreSQL server? - For pg_dump, execute: > >pg_dump --version > > And for the server, connect to it with psql and execute: > >select version(); > > I'm wondering if there's a version mismatch. > > I'm away for a few days from this evening, so hopefully others will be > able to help you. > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support > > -- View this message in context: http://old.nabble.com/get-the-copy-of-a-schema-tp26421440p26515271.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
