Re: 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