Re: [ADMIN] Database replication to 50-80 nodes

2013-10-02 Thread Jaime Casanova
On Wed, Oct 2, 2013 at 3:20 AM, Nikolay Morozov wrote: > Can I you database Master-Slave replication on cluster with 50-80 nodes. > Database is small (configuration), changed rarely. If there any problems > with such nodes count. > One master other slaves. Yes, you can... just set max_wal_senders

Re: [ADMIN] Database replication to 50-80 nodes

2013-10-02 Thread Sergey Konoplev
On Wed, Oct 2, 2013 at 1:20 AM, Nikolay Morozov wrote: > Can I you database Master-Slave replication on cluster with 50-80 nodes. > Database is small (configuration), changed rarely. If there any problems > with such nodes count. > One master other slaves. What do you need so many slaves for? --

Re: [ADMIN] pgAdmin forgets password on "could not connect to server" error

2013-10-02 Thread Walter Hurry
On Tue, 01 Oct 2013 08:17:37 -0600, Andrew Swartzendruber wrote: > Would it be possible to prevent the system from forgetting the stored > password when pgAdmin fails to connect in a future release or have an > option that would prevent forgetting of passwords? > > I use pgAdmin 1.16 or 1.18 to c

Re: [ADMIN] partitioning system tables

2013-10-02 Thread David Johnston
Radovan Jablonovsky wrote > Hello, > > When postgresql system tables, (tables in pg_catalog) reach size of 10mil > rows, it will slow down some DDL operations, which insert, update or > delete > data from pg_* tables. Is it possible to partition the system tables or is > there some other way to im

[ADMIN] partitioning system tables

2013-10-02 Thread Radovan Jablonovsky
Hello, When postgresql system tables, (tables in pg_catalog) reach size of 10mil rows, it will slow down some DDL operations, which insert, update or delete data from pg_* tables. Is it possible to partition the system tables or is there some other way to improve performance of the DDL operations?

Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

2013-10-02 Thread Chris Twombly
Do keep in mind that querying across databases generally garners really poor performance, and can bring your application to its knees with astonishing speed. From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on behalf of Albe Laur

Re: [ADMIN] Random server overload

2013-10-02 Thread Kevin Grittner
Igor Neyman wrote: >> Our Java application uses c3p0 connection pooler and we don't >> think that it's the issue. > > "Client-side" connection pooling is different from server-side > (such as PgBouncer), and I believe is not as effective as > PgBouncer. In my experience a good client-side pooler

Re: [ADMIN] PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects

2013-10-02 Thread Sergey Klochkov
I tried it out. It did not make any difference. On 01.10.2013 23:30, Alejandro Brust wrote: Did U perform any vacuumdb / reindexdb before the Pg_dump? El 01/10/2013 09:49, Magnus Hagander escribió: On Tue, Oct 1, 2013 at 11:07 AM, Sergey Klochkov wrote: Hello All, While trying to backup a

Re: [ADMIN] Random server overload

2013-10-02 Thread Igor Neyman
> -Original Message- > From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- > ow...@postgresql.org] On Behalf Of Viktor > Sent: Wednesday, October 02, 2013 4:12 AM > To: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Random server overload > > On 10/1/2013 4:45 PM, Igor Neyman

[ADMIN] Database replication to 50-80 nodes

2013-10-02 Thread Nikolay Morozov
Can I you database Master-Slave replication on cluster with 50-80 nodes. Database is small (configuration), changed rarely. If there any problems with such nodes count.

Re: [ADMIN] Random server overload

2013-10-02 Thread Viktor
On 10/1/2013 4:45 PM, Igor Neyman wrote: Did you try using any kind of connection pooler, e.g. PgBouncer? Should help. Our Java application uses c3p0 connection pooler and we don't think that it's the issue. On 10/1/2013 6:15 PM, Albe Laurenz wrote: Looks like something tries to open lots

Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

2013-10-02 Thread Albe Laurenz
Bhanu Murthy wrote: > Using Oracle Heterogeneous Services (Oracle HS) I have configured/created a > DB link from Postgres 9.3 > database into Oracle 11gR3 database (with postgres DB user credentials). > > SQL> create public database link pg_link connect to "postgres" identified by > "blahblah"

Re: [ADMIN] [SQL] DB link from postgres to Oracle; how to query Dbname.tablename?

2013-10-02 Thread Jayadevan M
In PostgreSQL, you always connect to a 'database', then query tables. So if you are connecting to the 'wrong' database, you will get the error you mentioned. You can troubleshoot this in many ways - one way would be to enable logging on PostgreSQL side and check the log and see which database you a