Re: [GENERAL] replication stops working

2013-07-08 Thread Daniel Serodio (lists)
John DeSoi wrote: I have a 9.2 hot standby setup with replication via rsync. For the second time, it has stopped working with no apparent error on the primary or standby. Last time this happened I fixed it by restarting the primary. Yesterday I started a new base backup around noon and it repl

Re: [GENERAL] Cannot connect to remote postgres database

2013-07-03 Thread Daniel Serodio (lists)
Stephen Carville wrote: I have been asked to evaluate Oracle, mysql and postgresql as a possible replacement for our existing Oracle and MsSQL databases. Oracle and mysql I pretty much have covered. Postgresql, OTOH, is somewhat less cooperative. I have the software (v 8.4.13) installed on 64 b

[GENERAL] AWS, cascading replication and WAL archiving

2013-07-03 Thread Daniel Serodio (lists)
I currently have a working 9.2 master + hot standby setup, using asynchronous replication and WAL archiving (via a shared NFS mount), running in our colocated datacenter. I need to migrate this to AWS, with as little downtime as possible. My plan is to create two cascading standbys, "daisy-cha

[GENERAL] Error registering at postgresql.org

2012-11-05 Thread Daniel Serodio (lists)
I'm trying to register at postgresql.org so I can edit the wiki to fix a broken link. I received a link on my e-mail so I could set my password, but when I submit the "Change password" form I get an error: Forbidden (403) CSRF verification failed. Request aborted. More information is available

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Daniel Serodio (lists)
Shaun Thomas wrote: On 10/17/2012 12:53 PM, Daniel Serodio (lists) wrote: I've come across a few mentions of Heartbeat being used for PostgreSQL failover, do have any links to more information about this? This was the subject of my talk at PG Open this year. I've got the ent

Re: [GENERAL] allow servers to access to the same data

2012-10-17 Thread Daniel Serodio (lists)
Tulio wrote: You can use a stream replication in hot standby (native) to have the same data and access in both (but not update and insert in the slave, just select) and create a virtual IP using heartbeat.. configuring a master to use some IP (virtual) and when this lost the IP, the second serv

Re: [GENERAL] database corruption questions

2012-10-17 Thread Daniel Serodio (lists)
Craig Ringer wrote: On 10/14/2012 05:53 AM, Heine Ferreira wrote: Hi Are there any best practices for avoiding database corruption? * Maintain rolling backups with proper ageing. For example, keep one a day for the last 7 days, then one a week for the last 4 weeks, then one a month for the

Re: [GENERAL] Is pg_basebackup also for "regular" backups?

2012-10-15 Thread Daniel Serodio (lists)
Magnus Hagander wrote: On Mon, Oct 15, 2012 at 10:15 PM, Daniel Serodio (lists) wrote: I was reading the documentation for pg_basebackup and it states that resulting backups "can be used both for point-in-time recovery and as the starting point for a log shipping or streaming replic

Re: [GENERAL] Help estimating database and WAL size

2012-10-15 Thread Daniel Serodio (lists)
John R Pierce wrote: On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote: 3) Estimate the size of the transaction log ** We've got no idea how to estimate this, need advice ** postgres doesn't have a 'transaction log', it has the WAL (Write-Ahead Logs). These are typi

Re: [GENERAL] Help estimating database and WAL size

2012-10-15 Thread Daniel Serodio (lists)
Jasen Betts wrote: On 2012-10-08, Daniel Serodio (lists) wrote: We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We're a team of developers with low expertise on database administration, so we are doing research, re

[GENERAL] Is pg_basebackup also for "regular" backups?

2012-10-15 Thread Daniel Serodio (lists)
I was reading the documentation for pg_basebackup and it states that resulting backups "can be used both for point-in-time recovery and as the starting point for a log shipping or streaming replication standby servers". Should pg_basebackup also be used for "regular" backups, or only for PITR

[GENERAL] Help estimating database and WAL size

2012-10-08 Thread Daniel Serodio (lists)
We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We're a team of developers with low expertise on database administration, so we are doing research, reading manuals and using our general IT knowledge to achieve this. We ha

Re: [GENERAL] RFE: Column aliases in WHERE clauses

2012-09-17 Thread Daniel Serodio (lists)
Ryan Kelly wrote: On Mon, Sep 17, 2012 at 06:18:53PM -0300, Daniel Serodio (lists) wrote: It would be nice if PostgreSQL supported column aliases in WHERE clauses, eg: SELECT left(value, 1) AS first_letter FROM some_table WHERE first_letter> 'a'; Is this the proper mailing

[GENERAL] RFE: Column aliases in WHERE clauses

2012-09-17 Thread Daniel Serodio (lists)
It would be nice if PostgreSQL supported column aliases in WHERE clauses, eg: SELECT left(value, 1) AS first_letter FROM some_table WHERE first_letter > 'a'; Is this the proper mailing list for such feature requests? Thanks in advance, Daniel Serodio -- Sent via pgsql-general mailing list (p