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
rod@iol.ie