Re: [NOVICE] Creating database problems

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