[GENERAL] Fedora 18 x86_64 repodata/repomd.xml: [Errno 14] curl#22 - "The requested URL returned error: 404 Not Found" on PostgreSQL 9.2

2013-03-14 Thread René Romero Benavides
Using the yum repository for PostgreSQL 9.2, does anybody know what happened to http://yum.postgresql.org/9.2/fedora/fedora-18-x86_64/repodata/repomd.xml? -- René Romero Benavides @iCodeiExist @PgsqlMx Postgresql Tips en español para la comunidad de México e Hispanoamérica. http

Re: [GENERAL] Streaming replication and sharding

2013-02-19 Thread René Romero Benavides
Looking forward to that release and best wishes for the project in general. On Tuesday, February 19, 2013 01:02:34 PM Michael Paquier wrote: On Tue, Feb 19, 2013 at 6:01 AM, René Romero Benavides wrote: There's also one project called Postgres-XC which seems very promising, but I'

Re: [GENERAL] Streaming replication and sharding

2013-02-18 Thread René Romero Benavides
abase restore > is needed, you have to make extra provisions that you can restore > your system to a consistent state across all clusters. > > You also lose the ability to join between tables that are > distributed across different databases. This can be a > perdormance prob

Re: [GENERAL] Streaming replication and sharding

2013-02-18 Thread René Romero Benavides
rential integrity, and if a database restore > is needed, you have to make extra provisions that you can restore > your system to a consistent state across all clusters. > > You also lose the ability to join between tables that are > distributed across different databases. This

Re: [GENERAL] PG9.2.3. Query hanging: SELECT count(*) FROM pg_catalog.pg_class...

2013-02-15 Thread René Romero Benavides
gt; c.relname = 'import_jobs' AND c.relpersistence = 'u' > > (I actually restarted the application and now there are 4 of these) > > Any idea why the query would hang like this? > > I don't see it waiting on locks or anything like that. > > any ideas? > > Thanks -- René Romero Benavides @iCodeiExist @PgsqlMx Postgresql Tips en español para la comunidad de México e Hispanoamérica. http://postgresql.org.mx

Re: [GENERAL] Failing backups, canceling statement due to conflict with recovery

2013-02-13 Thread René Romero Benavides
What does the following query give you on the standby ? select * from pg_settings where category = 'Replication / Standby Servers'; On Wednesday, February 13, 2013 03:53:33 PM Stuart Bishop wrote: > 'hot_standby_feedback = on' -- postgresql.org.mx -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] design question - repeated updates on temp or perm table.

2013-02-12 Thread René Romero Benavides
In general, temporary tables are way faster for writing than normal tables as they don't generate WAL records. On Tuesday, February 12, 2013 11:45:22 AM Little, Douglas wrote: Hi, Design question. Does it make a difference for a function to repeatedly update a temp table verses the perman

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread René Romero Benavides
El 24/06/2012 11:30 p.m., René Romero Benavides escribió: El 24/06/2012 09:53 p.m., Anibal David Acosta escribió: We have an old postgres installation (8.3) running on windows 2003 The server run perfect for many years but today it crash L We have a very old backup so I'll try despera

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread René Romero Benavides
El 24/06/2012 09:53 p.m., Anibal David Acosta escribió: We have an old postgres installation (8.3) running on windows 2003 The server run perfect for many years but today it crash L We have a very old backup so I'll try desperate to repair. If I can't repair I want to skip the error and start

Re: [GENERAL] describe command for

2012-06-08 Thread René Romero Benavides
Am 08.06.2012 14:50, schrieb Bartosz Dmytrak: 2012/6/8 Little, Douglas > Is there a postgres sql command/function that will display an object ddl? Hi, try some from this list: http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-I

Re: [GENERAL] describe command for

2012-06-08 Thread René Romero Benavides
Am 08.06.2012 14:31, schrieb Little, Douglas: Is there a postgres sql command/function that will display an object ddl?   I know of the psql metacharacters, but don’t know how I’d submit from a non-psql c

Re: [GENERAL] Two databases on the same server, looking for idea how to restrict access.

2012-06-08 Thread René Romero Benavides
Am 07.06.2012 23:03, schrieb Darren Duncan: Raymond O'Donnell wrote: On 07/06/2012 15:39, Condor wrote: I have two databases on postgresql in different servers, one main database and one secondary not much important, but the problem is they should use some tables both for reading and writing an

Re: [GENERAL] Question about load balance

2012-06-08 Thread René Romero Benavides
Am 08.06.2012 00:39, schrieb Craig Ringer: On 06/07/2012 10:26 PM, Condor wrote: Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load aver