Lawrence C wrote:
Hi Tim,
How do I setup cronjob for user "postgres" then in
scripts? that what i mean
thanks :)
log in or su to postgres and 'crontab -e' to edit the postgres crontab.
OR
as root 'crontab -u postgres -e'
--
Until later, Geoffrey Registered Linux User #108567
Hi Tim,
How do I setup cronjob for user "postgres" then in
scripts? that what i mean
thanks :)
--- tim hall <[EMAIL PROTECTED]> wrote:
> Lawrence C,
> On Wednesday 01 September 2004 14:20, you went:
> > Anyone good in writing Linux scripting for backup
> > PostgreSQL. I just required a simpl
On Thu, 2004-09-02 at 12:26, Kaolin Fire wrote:
>
> echo "1 3 * * * postgres /usr/local/bin/pg_dumpall >
> ~/backup.sql" >> /etc/crontab
>
> note to remember the two >>'s so you don't obliterate your crontab like
> I just did.
>
Would someone tell of a modification to this script
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Naomi Walker) would write:
> Anything would plain text would be a problem. Isnt .pgpass plain
> text?
Yes, it's plain text. How do you propose to improve on that?
At _some_ point, there has GOT to be a password in plain text form
that
Naomi Walker <[EMAIL PROTECTED]> writes:
> Anything would plain text would be a problem. Isnt .pgpass plain text?
Plain text is irrelevant. Securing the file properly is what's relevant
(and libpq will not read a .pgpass file with insecure permissions...)
regards, tom la
-- CONFIDENTIALITY NOTICE --
This
message is intended for the sole use of the individual and entity to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the intended
addressee, nor authorized t
Naomi Walker <[EMAIL PROTECTED]> writes:
> Christopher Browne wrote:
>>> One question , if you set access to server with password in
>>> pg_hba.conf how can you pass the apssword in the script?
>>
>> You don't have to if you put it in $HOME/.pgpass; see the
>> documentation for the format of that
-- CONFIDENTIALITY NOTICE --
This
message is intended for the sole use of the individual and entity to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the intended
addressee, nor authorized t
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Sandro Garoffolo) wrote:
> One question , if you set access to server with password in
> pg_hba.conf how can you pass the apssword in the script?
You don't have to if you put it in $HOME/.pgpass; see the
documentation for the format o
Geoffrey wrote:
Kaolin Fire wrote:
For that matter:
echo "1 3 * * * postgres /usr/local/bin/pg_dumpall >
~/backup.sql" >> /etc/crontab
note to remember the two >>'s so you don't obliterate your crontab
like I just did.
Unless things have changed, and they might have, you have to te
Kaolin Fire wrote:
For that matter:
echo "1 3 * * * postgres /usr/local/bin/pg_dumpall >
~/backup.sql" >> /etc/crontab
note to remember the two >>'s so you don't obliterate your crontab like
I just did.
Unless things have changed, and they might have, you have to tell cron
to reread
For that matter:
echo "1 3 * * * postgres /usr/local/bin/pg_dumpall >
~/backup.sql" >> /etc/crontab
note to remember the two >>'s so you don't obliterate your crontab like
I just did.
:ulp:
-kaolin
tim hall wrote:
Lawrence C,
On Wednesday 01 September 2004 14:20, you went:
Anyone
Lawrence C,
On Wednesday 01 September 2004 14:20, you went:
> Anyone good in writing Linux scripting for backup
> PostgreSQL. I just required a simple scripts only.
>
> Normally we do the manual ways as following:
>
> In root
>
> root# su - postgres
> bash# pgdumpall > backup.sql
> bash# exit
> ro
Hi All,
Anyone good in writing Linux scripting for backup
PostgreSQL. I just required a simple scripts only.
Normally we do the manual ways as following:
In root
root# su postgres
bash# pgdumpall > backup.sql
bash# exit
root#
Im planning to write script.sh for cronjob but not
too sure ab
14 matches
Mail list logo
