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
