pg_dump shell script with ~/.pgpass

Поиск
Список
Период
Сортировка
От MargaretGillon@chromalloy.com
Тема pg_dump shell script with ~/.pgpass
Дата
Msg-id OFF2A804D2.217FAC99-ON88256F8A.006DBF82-88256F8A.006E848B@CHROMALLOY.COM
обсуждение исходный текст
Список pgsql-general
I need to create a shell script for cron.daily to run that will do pg_dump
for my database. I am using Redhat 9 and Postgresql v7.3.4.  Currently when
I run the dump manually the command I use is

#pg_dump -u -C -D -f /tmp/owl.sql owl

What should the command look like using ~/.pgpass ?

My other question... Is cron.daily is being run by root? If so would I need
to put the .pgpass file in root's home directory?

I only have two postgresql users right now, myself and postgres.  On the
redhat server I have only two users, myself and root, there is no user
postgres.

TIA.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297


В списке pgsql-general по дате отправления:

Предыдущее
От: ntinos@aueb.gr
Дата:
Сообщение: Re: PQisBusy() always returns TRUE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Pgsql taking a *lot* of CPU time (unkillable).