pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
backups and WAL
6+ messages / 4 participants
[nested] [flat]

* backups and WAL
@ 2004-08-27 08:03 pablobarbachano@yahoo.es
  2004-08-27 08:40 ` Re: backups and WAL Gaetano Mendola <mendola@bigfoot.com>
  2004-08-27 14:28 ` Re: backups and WAL Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 6+ messages in thread

From: pablobarbachano@yahoo.es @ 2004-08-27 08:03 UTC (permalink / raw)
  To: pgsql-admin

Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.

Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs 
(cp pg_xlog/* ...) or do I need something more elaborate?

Now in a restore situation ... I restore the database, and then what?
put the saved files back in the pg_xlog/ dir, then start postmaster
and magically all starts working? Am I correct or completely insane?
The documentation is not clear in that aspect...

Thanks in advance,
Pablo.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backups and WAL
  2004-08-27 08:03 backups and WAL pablobarbachano@yahoo.es
@ 2004-08-27 08:40 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 6+ messages in thread

From: Gaetano Mendola @ 2004-08-27 08:40 UTC (permalink / raw)
  To: pablobarbachano@yahoo.es

pablobarbachano@yahoo.es wrote:

> Hi, first of all thanks for postgresql, it has never given a problem
> and is performing great.
> 
> Now my question: my employer wants to do backups every 12 hours, and
> save the logs evry 2 hours to... Can I simply save the logs 
> (cp pg_xlog/* ...) or do I need something more elaborate?
> 
> Now in a restore situation ... I restore the database, and then what?
> put the saved files back in the pg_xlog/ dir, then start postmaster
> and magically all starts working? Am I correct or completely insane?
> The documentation is not clear in that aspect...

I suppose that you use a pre 8.0 version, if yes take a look at:

http://www.postgresql.org/docs/7.4/interactive/backup.html


take also a look at PITR available in the future ( near I hope :-) )
8.0:

http://developer.postgresql.org/docs/postgres/backup-online.html



Regards
Gaetano Mendola





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backups and WAL
  2004-08-27 08:03 backups and WAL pablobarbachano@yahoo.es
@ 2004-08-27 14:28 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 6+ messages in thread

From: Tom Lane @ 2004-08-27 14:28 UTC (permalink / raw)
  To: pablobarbachano@yahoo.es; +Cc: pgsql-admin

pablobarbachano@yahoo.es writes:
> Now my question: my employer wants to do backups every 12 hours, and
> save the logs evry 2 hours to... Can I simply save the logs 
> (cp pg_xlog/* ...) or do I need something more elaborate?

You can't realistically do this in any pre-8.0 release; it's perhaps
doable in theory but there are too many gotchas to consider it a
trustworthy backup technique.

8.0 will have real support for log-based backup.  Feel free to try out a
beta --- we could use more people testing this feature.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backups and WAL
@ 2004-08-27 09:19 G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
  2004-08-27 09:51 ` Re: backups and WAL Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 1 reply; 6+ messages in thread

From: G u i d o B a r o s i o @ 2004-08-27 09:19 UTC (permalink / raw)
  To: mendola@bigfoot.com; pablobarbachano@yahoo.es; pgsql-admin

On this issue,

   Is a good idea to ln -s the pg_xlog directory onto another place, while the postmaster is running?

    I agree with pablo, documentation at this point is not easy to found. 

Regards,

> pablobarbachano@yahoo.es wrote:
> 
> > Hi, first of all thanks for postgresql, it has never given a problem
> > and is performing great.
> > 
> > Now my question: my employer wants to do backups every 12 hours, and
> > save the logs evry 2 hours to... Can I simply save the logs 
> > (cp pg_xlog/* ...) or do I need something more elaborate?
> > 
> > Now in a restore situation ... I restore the database, and then what?
> > put the saved files back in the pg_xlog/ dir, then start postmaster
> > and magically all starts working? Am I correct or completely insane?
> > The documentation is not clear in that aspect...
> 
> I suppose that you use a pre 8.0 version, if yes take a look at:
> 
> http://www.postgresql.org/docs/7.4/interactive/backup.html
> 
> 
> take also a look at PITR available in the future ( near I hope :-) )
> 8.0:
> 
> http://developer.postgresql.org/docs/postgres/backup-online.html
> 
> 
> 
> Regards
> Gaetano Mendola
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backups and WAL
  2004-08-27 09:19 Re: backups and WAL G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
@ 2004-08-27 09:51 ` Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Gaetano Mendola @ 2004-08-27 09:51 UTC (permalink / raw)
  To: gbarosio@uolsinectis.com.ar; +Cc: pablobarbachano@yahoo.es; pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

G u i d o B a r o s i o wrote:

| On this issue,
|
|
|
|    Is a good idea to ln -s the pg_xlog directory onto another place, while the postmaster is running?

I don't think so



|     I agree with pablo, documentation at this point is not easy to found.

I disagree instead:

1) Go on the first doc page:  http://www.postgresql.org/docs/7.4/interactive/index.html
2) Search for backups
3) The first 4 entries are what you have to know

Please do not take this as RTFM




Regards
Gaetano Mendola



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBLwQR7UpzwH2SGd4RAltoAKCMvcXuH4zbwleLDJaXXZ+tu6Q+/ACg5jB1
KvTAP2TiX5ZWFXiKvSTRIW0=
=GS6b
-----END PGP SIGNATURE-----




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backups and WAL
@ 2004-08-27 10:33 G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
  0 siblings, 0 replies; 6+ messages in thread

From: G u i d o B a r o s i o @ 2004-08-27 10:33 UTC (permalink / raw)
  To: mendola@bigfoot.com; pablobarbachano@yahoo.es; pgsql-admin

What I meant(And I guess that Pablo asked for this also), was that is not easy to found information or howto work on the pg_xlog directory. 

I didn't take it as "read the FINE manual" anyway ;)

Regards,
Guido

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> G u i d o B a r o s i o wrote:
> 
> | On this issue,
> |
> |
> |
> |    Is a good idea to ln -s the pg_xlog directory onto another place, while the postmaster is running?
> 
> I don't think so
> 
> 
> 
> |     I agree with pablo, documentation at this point is not easy to found.
> 
> I disagree instead:
> 
> 1) Go on the first doc page:  http://www.postgresql.org/docs/7.4/interactive/index.html
> 2) Search for backups
> 3) The first 4 entries are what you have to know
> 
> Please do not take this as RTFM
> 
> 
> 
> 
> Regards
> Gaetano Mendola
> 
> 
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.4 (MingW32)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
> 
> iD8DBQFBLwQR7UpzwH2SGd4RAltoAKCMvcXuH4zbwleLDJaXXZ+tu6Q+/ACg5jB1
> KvTAP2TiX5ZWFXiKvSTRIW0=
> =GS6b
> -----END PGP SIGNATURE-----
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2004-08-27 14:28 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-27 08:03 backups and WAL pablobarbachano@yahoo.es
2004-08-27 08:40 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-27 14:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-08-27 09:19 Re: backups and WAL G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
2004-08-27 09:51 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-27 10:33 Re: backups and WAL G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox