Pg_dump options
Is there a way to supply a username and password in one command using
pg_dump?
For example is it possible to do this so it doesn't prompt you for a
username/password:
pg_dump mydb --username=dbuser --password=dbpass > myfile.out
Thank you!
[:==> Troy Campano <==:]
Hello Troy,
You could use one of these things to get it working..
Create one txt file, input the username and password in different
lines like
Username
Password
save the file(user.txt)...
Give this file as input to the pg_dump it should work
pg_dump dummy_db < user.txt > /tmp/dummy_db.sql
Hope it solves the problem, it worked for me...
Gurudutt
Tuesday, January 29, 2002, 12:38:07 AM, you wrote:
TCLc> Is there a way to supply a username and password in one command using
TCLc> pg_dump?
TCLc> For example is it possible to do this so it doesn't prompt you for a
TCLc> username/password:
TCLc> pg_dump mydb --username=dbuser --password=dbpass > myfile.out
TCLc> Thank you!
[:==>> Troy Campano <==:]
--
Best regards,
Gurudutt mailto:guru@indvalley.com
Life is not fair - get used to it.
Bill Gates
Tuesday, January 29, 2002, 7:34:17 AM, Gurudutt wrote:
Hello Troy,
You could use one of these things to get it working..
Create one txt file, input the username and password in different
lines like
Username
Password
save the file(user.txt)...
Give this file as input to the pg_dump it should work
pg_dump dummy_db < user.txt > /tmp/dummy_db.sql
Hope it solves the problem, it worked for me...
yes, it works BUT you will have lines "Username:" and "Password:" in
your dump file. I think better to have these options in pg_dump (like
mysql_dump has) instead of doing this work around.
--
Dimitry
Hello Dmitry,
Yes!! I fully agree with what you say, the option should've been there
in pg_dump just the way it is in mysql_dump. But Username: & Password:
won't be there in the dump file if u write the pg_dump command in a
shell script and execute it inside the shell.
Tuesday, January 29, 2002, 1:10:06 PM, you wrote:
DA> Tuesday, January 29, 2002, 7:34:17 AM, Gurudutt wrote:
Hello Troy,
You could use one of these things to get it working..
Create one txt file, input the username and password in different
lines like
Username
Password
save the file(user.txt)...
Give this file as input to the pg_dump it should work
pg_dump dummy_db < user.txt > /tmp/dummy_db.sql
Hope it solves the problem, it worked for me...
DA> yes, it works BUT you will have lines "Username:" and "Password:" in
DA> your dump file. I think better to have these options in pg_dump (like
DA> mysql_dump has) instead of doing this work around.
--
Best regards,
Gurudutt mailto:guru@indvalley.com
Life is not fair - get used to it.
Bill Gates
On Tue, 2002-01-29 at 03:27, Gurudutt wrote:
Hello Dmitry,
Yes!! I fully agree with what you say, the option should've been there
in pg_dump just the way it is in mysql_dump.
IIRC, it has been discussed, but was rejected because passing a password
on a command line cannot generally be made secure.
Responding to a propmt can. A variety of other methods can. But command
lines are sniffable in many (most? all?) environments.
--
Karl
Yes, you're right. But why do not make it like --user and
--read-password-from-stdin-without-promtp options ?
--
Dimitry
Tuesday, January 29, 2002, 11:16:21 AM, Karl DeBisschop wrote:
Show quoted text
On Tue, 2002-01-29 at 03:27, Gurudutt wrote:
Hello Dmitry,
Yes!! I fully agree with what you say, the option should've been there
in pg_dump just the way it is in mysql_dump.
IIRC, it has been discussed, but was rejected because passing a password
on a command line cannot generally be made secure.
Responding to a propmt can. A variety of other methods can. But command
lines are sniffable in many (most? all?) environments.
--
Karl
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On Tue, 2002-01-29 at 04:45, Dmitry Alyabyev wrote:
Yes, you're right. But why do not make it like --user and
--read-password-from-stdin-without-promtp options ?
In the man page for pg_dump in7.2:
-U username
Connect as the given user.
-W Force a password prompt. This should happen auto-
matically if the server requires password authenti-
cation.
And the password prompt does not write into your dump file.
--
Karl
Sorry, I didn't check it for 7.1 branch - but it definitely happened
for 7.0
--
Dimitry
Tuesday, January 29, 2002, 12:30:16 PM, Karl DeBisschop wrote:
Show quoted text
On Tue, 2002-01-29 at 04:45, Dmitry Alyabyev wrote:
Yes, you're right. But why do not make it like --user and
--read-password-from-stdin-without-promtp options ?
In the man page for pg_dump in7.2:
-U username
Connect as the given user.
-W Force a password prompt. This should happen auto-
matically if the server requires password authenti-
cation.
And the password prompt does not write into your dump file.
--
Karl
Hi,
YOu could do it by using expect:
Here is a sample code:
---------------
1. backup.sh
#!/usr/bin/expect -f
set env(SHELL) /bin/sh
set env(HOME) /usr/sbin/
spawn /usr/sbin/createdbbackups.sh
expect Username:
send postgres\r
expect Password:
send YourPasswdHere\r
2.createdbbackups.sh
pg_dump mydb > mydb.pgdump -p 5456 -u;
---------------
If you are having a backup for more than one database, you should write
their names in the second file, and write the last four lines in the first
file (beginning with expect, ending with the passwd line) as many as the
number of your databases.
Regards and best wishes,
--
Devrim G�ND�Z
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net
Phone : +90-535-328-9594 (cellular)-
Phone : +90-312-295-9595 (work)
Phone : +90-312-286-5906 (home)
Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------
On Mon, 28 Jan 2002 Troy.Campano@LibertyMutual.com wrote:
Show quoted text
Is there a way to supply a username and password in one command using
pg_dump?For example is it possible to do this so it doesn't prompt you for a
username/password:pg_dump mydb --username=dbuser --password=dbpass > myfile.out
Thank you!
[:==> Troy Campano <==:]
