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

Re: Pg_dump options

From: Gurudutt <guru(at)indvalley(dot)com>
To: Troy(dot)Campano(at)LibertyMutual(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg_dump options
Date: 2002-01-29 05:34:17
Message-ID: (view raw or whole thread)
Lists: pgsql-general
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


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...


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(at)indvalley(dot)com

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

In response to


pgsql-general by date

Next:From: Lamar OwenDate: 2002-01-29 05:36:06
Subject: Re: 7.2 RPMs (Re: [HACKERS] PostgreSQL v7.2rc2 Released)
Previous:From: Jason WatkinsDate: 2002-01-29 05:28:56
Subject: Re: Moving my business to PostgreSQL

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