Postgres Pro
Downloads
Home   >   mailing lists

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

From Rouzzi Anissa
Subject [NOVICE] Creating database problems
Date
Msg-id CA+1FhNpnxHHNbABtZabTB6=u6n5TQrMd8h6gRxHJdcNF-W+1Rw@mail.gmail.com
Whole thread Raw
Responses Re: [NOVICE] Creating database problems
List pgsql-novice
Tree view
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 

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: [NOVICE] FDW user mapping
Next
From: Andreas Kretschmer
Date:
Subject: Re: [NOVICE] Creating database problems