Skip site navigation (1) Skip section navigation (2)

Re: Pg_dump options

From: Gurudutt <guru(at)indvalley(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg_dump options
Date: 2002-01-29 08:27:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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(at)indvalley(dot)com

Life is not fair - get used to it.
Bill Gates

In response to


pgsql-general by date

Next:From: Carsten GreweDate: 2002-01-29 08:43:51
Subject: problem with to_char
Previous:From: Dmitry AlyabyevDate: 2002-01-29 07:40:06
Subject: Re: Pg_dump options

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group