Postgres Pro
Downloads
Home   >   mailing lists

Thread: [NOVICE] Creating database problems

[NOVICE] Creating database problems

From
Rouzzi Anissa
Date:
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 

Re: [NOVICE] Creating database problems

From
Andreas Kretschmer
Date:

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