Re: [GENERAL] replication stops working

how did you conclude that replication has stopped working? Since you're using a hot standby, you've also setup streaming replication in addition to the WAL archiving, correct? Regards, Daniel Serodio -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Cannot connect to remote postgres database

ers, which is probably not what you want. Any hints on where to start looking? Is there any NAT happening between the client and the server? Check the server's log for a "LOG: connection received: host=x.x.x.x" message so you can check which IP is reaching the server. Regards,

[GENERAL] AWS, cascading replication and WAL archiving

atically follows S2 when promoted to master? "recovery_target_timeline = latest" ? Thanks in advance, Daniel Serodio [1] https://github.com/wal-e/wal-e -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Error registering at postgresql.org

on is available with DEBUG=True. I've tried appending "?DEBUG=True" to the URL but got no further information. Can someone help? Thanks, Daniel Serodio -- 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] allow servers to access to the same data

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] database corruption questions

er absorbing a few surges, becoming totally ineffective. Since your system should be crash-safe a cheap UPS will do nothing for corruption protection, it'll only help with uptime. -- Craig Ringer Thanks, Daniel Serodio -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

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

s the same data from two different servers. the two servers have the same IP and not run simultaneously Thanks in advance, Daniel Serodio

Re: [GENERAL] database corruption questions

er absorbing a few surges, becoming totally ineffective. Since your system should be crash-safe a cheap UPS will do nothing for corruption protection, it'll only help with uptime. -- Craig Ringer Thanks, Daniel Serodio -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

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

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

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

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?

backups, or only for PITR/streaming replication? Regards, Daniel Serodio -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Help estimating database and WAL size

We've also posted this question to http://dba.stackexchange.com/q/25617/10166 Thanks in advance, Daniel Serodio -- 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] RFE: Column aliases in WHERE clauses

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

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

Re: [GENERAL] Question about encoding

gt; possible using the LIKE > syntax. What a pity, I've found a point where Microsoft SQL Server is better than PostgreSQL ! :-) How should I go about filing an RFE or equivalent? TIA, Daniel Serodio ---(end of broadcast)--- TIP 9: In versions

Re: [GENERAL] IS it a good practice to use SERIAL as Primary Key?

"Joshua D. Drake" wrote: > > That's it, in a nut shell. There is no argument there. That is why you > don't use artificial keys. That said... pretty much every table I create > will have an artificial key... because it makes managing data easy. An > example (to reuse the simple example): > > us

[GENERAL] Question about encoding

Is it possible to configure PostgreSQL so that a " LIKE 'a' " query will match a 'á' value, ie, make it accent-insensitive ? Thanks in advance, Daniel Serodio ---(end of broadcast)--- TIP 3: Have you checked our exten

[GENERAL] varchar(n) vs. varchar

I've found a thread discussing the use of "text" vs. "varchar"; what I'd like to know if there's any performance difference between using "varchar(n)" vs. "varchar", ie, should I constrain a "name" column to an arbitrary length to improve performance, or will it actually degrade performance because