Re: 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
rod(at)iol(dot)ie