THANKS ALL...
--
View this message in context:
http://www.nabble.com/Automating-Backup---Restore-tf4684052.html#a13392360
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the p
On 10/24/07, smiley2211 <[EMAIL PROTECTED]> wrote:
>
>
> Hello all,
>
> Does someone have a script that backups a database from one server and
> restores it to another server??? I am NEW to Postgresql so I am starting
> from scratch...
>
> so, in essence - what I want to do is (I CURRENTLY DO THI
Jan de Visser wrote:
On Wednesday 24 October 2007 10:39:23 smiley2211 wrote:
Does someone have a script that backups a database from one server
and restores it to another server??? I am NEW to Postgresql so I
am starting from scratch...
$ pg_dump -h server1 database | psql -h server2
jan
On Wednesday 24 October 2007 10:39:23 smiley2211 wrote:
> Does someone have a script that backups a database from one server and
> restores it to another server??? I am NEW to Postgresql so I am starting
> from scratch...
$ pg_dump -h server1 database | psql -h server2
jan
--
-
Hello all,
Does someone have a script that backups a database from one server and
restores it to another server??? I am NEW to Postgresql so I am starting
from scratch...
so, in essence - what I want to do is (I CURRENTLY DO THIS MANUALLY):
Server1 (IS IT POSSIBLE TO DUMP DIRECTLY TO SERVER2?
Richard Sydney-Smith wrote:
Hi Doug.
Many users are haphazard in their approach until the machine fails and
then they expect to be pulled from the poo.
Done it too many times. I now will get the application to enforce an
additional integrity check. It must be backed up or else! Seems futile
Thanks Doug. Think hacking the source may be the way to go. I will ask
the Postgres bosses if this the idea is acceptable.
We are only going to store two data items somewhere. One key-timestamp
for each of autovacuum and pgdump
Doug McNaught wrote:
Richard Sydney-Smith <[EMAIL PROTECTED]>
Hi Doug.
Many users are haphazard in their approach until
the machine fails and then they expect to be pulled from the poo.
Done it too many times. I now will get the application to enforce an
additional integrity check. It must be backed up or else! Seems futile
to put all the effort into a
Richard Sydney-Smith <[EMAIL PROTECTED]> writes:
> pch := pchar('pg_dump -C -h '+host+' -U '+usr+' -p '+pswd+ ' -f
> '+bckup_path+' '+dbase);
>
> to postgres.
>
> as the operator is obviously logged in how do I
> (1) trap their user id
> (2) Send the call to pg_dump without knowing their pas
I presently use the following to export the database and as per my
earleir post hope to have an equivent to do the backup as per:
a) check for time since the last backup
b) if older than hrs
(i) perform a vacuum analyze
(ii) force a call to dbbackup
(iii) add a new record into fsysl
I would like each database to encapsulate its own backup procedure.
Each database contains a table (fsyslog) which has a record of each
backup taken:
At the application level I presently
a) check for time since the last backup
b) if older than hrs
(i) perform a vacuum analyze
(ii)
; <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 29, 2005 1:56 AM
Subject: Re: [GENERAL] automating backup ?
Zlatko Matic schrieb:
Now I have pgpass.conf file in D:\Documents and
Settings\Zlatko\Application Data\postgresql
content of pgpass.conf is:
localhost:*:MONITORINGZ:postgres:tralalala
PROTECTED]>;
Sent: Tuesday, June 28, 2005 7:55 PM
Subject: RE: [GENERAL] automating backup ?
1) Create the directory %APPDATA%\postgresql
in my case it's C:\Documents and
Settings\Administrator\Application Data\postgresql
2) Create the file %APPDATA%\postgresql\pgpass.conf
I created
Zlatko Matic schrieb:
Now I have pgpass.conf file in D:\Documents and
Settings\Zlatko\Application Data\postgresql
content of pgpass.conf is:
localhost:*:MONITORINGZ:postgres:tralalala
content of backup_script.bat is:
cd D:\Program Files\PostgreSQL\8.0\bin
pg_dumpall >D:\MONITORINGZ_DUMPALL -U
pts for password...What is wrong ?
- Original Message -
From: "Relyea, Mike" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 7:55 PM
Subject: RE: [GENERAL] automating backup ?
1) Create the directory %AP
esql.org
Subject: Re: [GENERAL] automating backup ?
I would appreciate some example.
Thanks.
- Original Message -
From: "Relyea, Mike" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 3:56 PM
Subject: Re: [GENERAL] au
I would appreciate some example.
Thanks.
- Original Message -
From: "Relyea, Mike" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 3:56 PM
Subject: Re: [GENERAL] automating backup ?
That's because they
"Zlatko Matic" <[EMAIL PROTECTED]> writes:
> Hi.
> I can't find pgpass.conf file. It should be in Application Data
> subdirectory, but there is no PostgreSQL subdirectory in Application
> Data directory (!?). I couldn't find pgpass.conf even by searching the
> hard disk..
I'm pretty sure it's not
Zlatko Matic schrieb:
I can't find pgpass.conf file. It should be in Application Data
subdirectory, but there is no PostgreSQL subdirectory in Application
Data directory (!?). I couldn't find pgpass.conf even by searching the
hard disk..
you have to create the sub-dir and the file yourself
gresql.org
Subject: Re: [GENERAL] automating backup ?
Importance: High
Hi.
I can't find pgpass.conf file. It should be in Application Data
subdirectory, but there is no PostgreSQL subdirectory in Application
Data
directory (!?). I couldn't find pgpass.conf even by searching the hard
dis
Magnus Hagander" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>; "Andreas" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 10:16 AM
Subject: Re: [GENERAL] automating backup ?
Hello.
I created a Windows XP schedule for backup, following your
> Hello.
> I created a Windows XP schedule for backup, following your
> instruction. Now I have a .bat file with this script:
>
> cd D:\Program Files\PostgreSQL\8.0\bin
> pg_dumpall >D:\MYDATABASE_DUMPALL -U postgres pg_dumpall
> >D:\MYDATABASE_SHEMA -U postgres -s pg_dumpall
> >D:\MYDATABASE_G
;
To:
Cc: "Zlatko Matic" <[EMAIL PROTECTED]>
Sent: Monday, June 27, 2005 12:43 PM
Subject: Re: [GENERAL] automating backup ?
Zlatko Matic schrieb:
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
That's again a pure Windows issue, but not commonly n
thank you Andreas!
- Original Message -
From: "Andreas" <[EMAIL PROTECTED]>
To:
Cc: "Zlatko Matic" <[EMAIL PROTECTED]>
Sent: Monday, June 27, 2005 12:43 PM
Subject: Re: [GENERAL] automating backup ?
Zlatko Matic schrieb:
Thanks Fuhr.
Anybody can te
Zlatko Matic schrieb:
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
That's again a pure Windows issue, but not commonly needed.
I guess, it should be in the Windows PG-FAQ, too.
I'll describe the way you go with Windows 2000.
If you are lucky WinXP Pro does it the sam
On Sun, 2005-06-26 at 11:18 +0200, Zlatko Matic wrote:
> How to automate backup, so that Postgres automatically backups, for example,
> once in a week ?
> The same question about vacuum ?
>
> Concerning backup, how to prevent that someone makes a copy (for example
> pg_dumpall) of a database,
Start->Control Panel->Scheduled Tasks
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Zlatko Matic
> Sent: Monday, 27 June 2005 9:21 AM
> To: Michael Fuhr
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] automat
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, June 26, 2005 2:59 PM
Subject: Re: [GENERAL] automating backup
On Sun, Jun 26, 2005 at 06:59:14AM -0600, Michael Fuhr wrote:
> On Sun, Jun 26, 2005 at 11:18:31AM +0200, Zlatko Matic wrote:
> >
> > How to automate backup, so that Postgres automatically backups, for
> > example, once in a week ?
>
> Using the operating system's mechanism for scheduling jobs to
On Sun, Jun 26, 2005 at 11:18:31AM +0200, Zlatko Matic wrote:
>
> How to automate backup, so that Postgres automatically backups, for
> example, once in a week ?
Using the operating system's mechanism for scheduling jobs to run
periodically. For example, cron on Unix-like systems.
> The same qu
How to automate backup, so that Postgres automatically backups, for example,
once in a week ?
The same question about vacuum ?
Concerning backup, how to prevent that someone makes a copy (for example
pg_dumpall) of a database, then installs new instance of Postgres, create
the same user acount
31 matches
Mail list logo
