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

Re: Backing up postgresql databases

From: Thierry Besancon <Thierry(dot)Besancon(at)prism(dot)uvsq(dot)fr>
To: Tim Frank <tfrank(at)registrar(dot)uoguelph(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up postgresql databases
Date: 2001-03-20 08:33:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Dixit Tim Frank <tfrank(at)registrar(dot)uoguelph(dot)ca> (le Tue, 20 Mar 2001 00:14:11 GMT) :

» 	Have your shell script do
» export PGUSER=username
» export PGPASSWORD=password
» before you run pg_dumpall in the same script.  The user/pass would most 
» likely have to be a superuser to have access to all databases (this is 
» also not guaranteed depending on your pg_hba.conf).  Make the script 
» read/execute by root but not by anyone else and it will help a tiny bit 
» with security.

Using something like "ps -e" shows the environment variables so it is
as unsecure as giving the password on the commande line.


In response to


pgsql-admin by date

Next:From: J.H.M. Dassen RayDate: 2001-03-20 11:23:39
Subject: Re: Re: cannot create new user in postgres
Previous:From: Tom LaneDate: 2001-03-20 06:34:28
Subject: Re: Moving databases

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