Обсуждение: [NOVICE] Creating database problems
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%"
createdb -h %Server% -U postgres -p 5432 %NewDatabase%
pg_restore -h %Server% -U postgres -d %NewDatabase% Fichier.dump
but that doesn't work for me , i think it is a problem of password so i used Set PGPAssword and
PGPAssFile but that didn"t work for me
how can achieve that?
Thanks
Cordialement
ROUZZI Anissa
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