CRON Jobs and Backups

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

In response to

Responses

Browse pgsql-novice by date

  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()