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