From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | CRON Jobs and Backups |
Date: | 2005-06-06 17:07:39 |
Message-ID: | 20050606170739.14446.qmail@web52404.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi all,
i've googled and searche dmy pgsql books and i can't
quite get a confident grasp on cron jobs.
as i understand it... the following should enable me
to backup via cron:
PGUSER=postgres
PGPASSWORD=password
export PGUSER PGPASSWORD
pg_dump databasename | gzip > databasename.bak.gz
my interfaces is cpanel and it only gives me one line
to type this in... can i replace the returns with a
space and will this still work?
eg, PGUSER=postgres PGPASSWORD=password export...
will databasename.bak.gz be stored in the same file as
my database?
how can i store the file on my local computer?
i finally have some data in my db and i scared of
losing it. *real* scared!
tia...
__________________________________
Discover Yahoo!
Have fun online with music videos, cool games, IM and more. Check it out!
http://discover.yahoo.com/online.html
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Hallstrom | 2005-06-06 17:49:19 | Re: CRON Jobs and Backups |
Previous Message | Tom Lane | 2005-06-06 14:28:22 | Re: PQconsumeInput() usage in PQgetCopyData() |