[GENERAL] warm database, tape device backup
Hi! I have few question regarding new PostgreSQL database installation. The potential installation will have to manage over 1.5 TB of data. Since our customers have an increasing demand for high availability, we decided to try with PostgreSQL's concept of warm standby database (http://www.postgresql.org/docs/8.3/static/warm-standby.html). Apart from having a standby database, we MUST HAVE an enterprise class reliable backup soltuion and the backup is our major concern now. My first question is: is there any commercial solution for on-line backup directly to tape device, eg like HP Data Protector or EMC NetWorker module for Oracle? Can we use on-line backup (http://www.postgresql.org/docs/8.1/static/backup-online.html) using pg_start_backup and place backup segments onto a tape device directly, without using the disk storage temporarily (because we have 1,5 TB database)? Another question is: Do you have some positive experience regarding warm standby databases of this size? Kind regards Milos Babic
Re: [GENERAL] This is my first template
There are 30 days in April. On Apr 21, 2009 2:34pm, Merlin Moncure wrote: On Tue, Apr 21, 2009 at 7:02 AM, Geoff Caplan ge...@uviva.com> wrote: > Hi folks > > Looks like there's something I'm not understanding about date/time queries > on a date field. > > I have a param query that includes the statement: > > AND active_from_date > > where $2 is a well-formed ISO date. > > Query works as expected when there are records in the result set. When the > result set is empty, PG throws an error: > > date/time field value out of range: "2011-4-31" "2011-4-31" is not a well formed ISO date. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] recover corrupt DB?
Yes. Some things like duplicate primary key can exist in pg_resetxlog-ed db. So, dump db and restore it again on clean initialized cluster. Regards Milos On Thu, Apr 23, 2009 at 8:25 PM, Dan Armbrust < daniel.armbrust.l...@gmail.com> wrote: > > In general, pg_resetxlog would be > > the tool to try here. Don't panic yet. ;-) > > > > > > Yep, that was the command I was looking for. That at least got the DB > to a point where it would start, and I was able to do a dump. > > So, I dumped and reloaded all of the databases. Things seem fine, but > bits and pieces of documentation I've seen for pg_resetxlog also > recommend initdb, and starting over. Is that necessary? > > Thanks, > > Dan > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
