How to run pg_restore

[Nitin Jawarkar]

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

[Dilipan Sebastiampillai]

I know that

pg_dumpall -g

gives you user/groups only.


Dilipan

Post by Nitin Jawarkar
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html