> FattahRozzaq <ssoor...@gmail.com> hat am 10. Dezember 2015 um 01:27 > geschrieben: > > > Hi John, > > I really don't know why I should keep the wal archives.
That's the problem! But that's your part, not our. If you need a Backup with PITR-capability you have to create a so called basebackup and continously WAL's. If you create later, say the next day, a new Basebackup and your Backup-Policy is hold one Backup, than you can delete all WAL's untill to the new Basebackup and the old Backup. If i where you i would use somethink like barman (see: http://www.pgbarman.org/ ) for that. And yes: you should a extra Backup-Server. If you have both (Database and Backup) on the same machine and the machine burns you will lost both, data and backup. Questions? > I implement streaming replication into 1 server (standby server). Streamin Replication can't replace a Backup! > I'm really newbie to PostgreSQL but the boss pushed me to handle it > and implement it in production f*&%*$%%$#%$#&# (forgive me) > They don't hire a database expert, I don't know why. You can learn that. PostgreSQL is really, really great. Btw.: i know companies providing remote DBA service for PostgreSQL. > http://blog.endpoint.com/2014/09/pgxlog-disk-space-problem-on-postgres.html > And I change the archive_command into: archive_command = '/bin/true' > Is it a bad decision? Maybe. You don't have a backup now. In case of desaster your boss will fire YOU! (and not me) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
