Re: [NOVICE] Creating database problems - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: [NOVICE] Creating database problems
Date
Msg-id 4005d35c-04bf-9405-e6ab-b1d9784da6b3@a-kretschmer.de
Whole thread Raw
In response to [NOVICE] Creating database problems  (Rouzzi Anissa <rouzzi.anissa@gmail.com>)
List pgsql-novice

Am 01.10.2017 um 13:50 schrieb Rouzzi Anissa:
> Hello,
>
> Within my application , i need to create a new database from 
> existanting database so i'm using this batch :
>
> *cd "C:\Program Files\Postgresql\9.5\bin"*
> *
> *
> *pg_dump.exe --host %Server% --port 5432 --username "postgres" 
> --no-password  --format custom --blobs --verbose   "%DatabaseModel%"*

the pg_dump dumps to stdout, not to a file ...

> *
> *
> *
> *
> *createdb -h %Server% -U postgres -p 5432 %NewDatabase%*
> *
> *
> *
> *
> *pg_restore -h %Server% -U postgres -d %NewDatabase% Fichier.dump*
>

there isn't a file *Fichier.dump, *i would guess...


>
> but that doesn't work for me , i think it is a problem of password so 
> i used Set PGPAssword and

doesn't work isn't a precise error description...


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: Rouzzi Anissa
Date:
Subject: [NOVICE] Creating database problems
Next
From: Peng Yu
Date:
Subject: [NOVICE] How extract data from pg_dump'ed files to tsv files?