Thread: How to run pg_restore

How to run pg_restore

From
"Nitin Jawarkar"
Date:
hello,
 
            I have create database and run "psql -d databasename -f filename(.out)" so according to this it restores all data but not create users, i want to create users so how it can be done plz tell me. I should run .sql file in or create it.
 
 
With Regard
Nitin Jawarkar

Re: How to run pg_restore

From
Dilipan Sebastiampillai
Date:
I know that

pg_dumpall -g

gives you user/groups only.


Dilipan




Nitin Jawarkar wrote:

> hello,
>
>             I have create database and run "psql -d databasename -f
> filename(.out)" so according to this it restores all data but not
> create users, i want to create users so how it can be done plz tell
> me. I should run .sql file in or create it.
>
>
> With Regard
> Nitin Jawarkar