[GENERAL] virtualxid,relation lock

Hii, I have an issue with of "idle transaction" and one select statement in backend. what i noticed when i look the pg_lock, all are idle trans and one particlular select statement with virtualxid,relation lock. the lock are held with diffrend objects.it utilise the whole cpu.How can fix the issu

Re: [GENERAL] Problem creating index

2013/8/28 Dan Langille > Same version of DB for dump & restore? If not, was the dump done via the > pg_dump from the newer version. If not, please do that. > > I'm using the same version. I make this test on the same machine. Moreover I try to remove this line using pgadmin and I get the same err

Re: [GENERAL] Problem creating index

On Wed, Aug 28, 2013 at 1:08 PM, Torello Querci wrote: > Again, is very strange that this data is in the database moreover this > data came from a import procedure and this data is not present in the source > import file. > Really, I think that I get some kind of data corruption I'm sure yo

Re: [GENERAL] Problem creating index

2013/8/28 Luca Ferrari > On Wed, Aug 28, 2013 at 1:08 PM, Torello Querci wrote: > > Again, is very strange that this data is in the database moreover > this > > data came from a import procedure and this data is not present in the > source > > import file. > > Really, I think that I get som

[GENERAL] Problems with adding IP to pg_hba.conf

Hi all, I need to let a server access our postgreSQL database but I´m having problems with the configuration. I´m getting the error message below, psql: FATAL:  no pg_hba.conf entry for host "10.24.17.22", user "k175", database "k175", SSL off I´ve added the section below to the pg_hba.conf #

Re: [GENERAL] Problems with adding IP to pg_hba.conf

On 2013-08-28 2:00 PM, Chrishelring wrote: Hi all, I need to let a server access our postgreSQL database but I´m having problems with the configuration. I´m getting the error message below, psql: FATAL: no pg_hba.conf entry for host "10.24.17.22", user "k175", database "k175", SSL off I´ve ad

Re: [GENERAL] Problems with adding IP to pg_hba.conf

On 08/28/2013 07:00 AM, Chrishelring wrote: psql: FATAL: no pg_hba.conf entry for host "10.24.17.22", user "k175", database "k175", SSL off Did you reload the configuration files after changing pg_hba.conf? If not, you need to use the init script, or pg_ctl and send a reload command. -- Sh

[GENERAL] postgres 9.2

Hi all, I recently ran a couple of tests where I took one of my production systems and did a drop-in replacement of postgres 8.4 with 9.2.4. I was expecting to see some performance improvement given the release notes describing 9.2 as a "largely performance related release". At least for my appli

Re: [GENERAL] Pgbouncer help

Thanks Jeff, As I understand from your point, instead of connecting Postgresql port, try to use PgBouncer port. I am using libpq library functions connect postgreql and code changes would be like this. Previous code : sprintf(conninfo, "user=%s password=%s dbname=%s hostaddr=%s port=%d", PG

Re: [GENERAL] Problem creating index

Same version of DB for dump & restore? If not, was the dump done via the pg_dump from the newer version. If not, please do that. -- Dan Langille http://langille.org/ On Aug 28, 2013, at 2:56 AM, Torello Querci wrote: > Interesting . > > while trying to restore the database on the same

Re: [GENERAL] Pgbouncer help

Thanks for your great inputs. Let me see, how to handle these situations in our project. Regards, Ramkumar -Original Message- From: Steve Crawford [mailto:scrawf...@pinpointresearch.com] Sent: Wednesday, August 28, 2013 1:09 AM To: Jeff Janes Cc: Yelai, Ramkumar IN BLR STS; pgsql-genera

Re: [GENERAL] pg_extension_config_dump() with a sequence

Thank you very much, Tom. That was it. Our other server is running 9.1.9 and that's why it worked there. On Tue, Aug 27, 2013 at 10:50 PM, Tom Lane wrote: > Moshe Jacobson writes: > > On Tue, Aug 20, 2013 at 7:58 PM, Tom Lane wrote: > >> Well, I think you did it wrong, or else you're using a

Re: [GENERAL] regexp idea

AI Rumman escribió: > Thanks. That's awesome. > Do you have any good guide where I may get more knowledge on REGEXP? This book is awesome: http://regex.info/book.html -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent

Re: [GENERAL] postgres 9.2

On 08/27/2013 02:26 PM, pg noob wrote: Hi all, I recently ran a couple of tests where I took one of my production systems and did a drop-in replacement of postgres 8.4 with 9.2.4. I was expecting to see some performance improvement given the release notes describing 9.2 as a "largely performanc

Re: [GENERAL] postgres 9.2

On Tue, Aug 27, 2013 at 2:26 PM, pg noob wrote: > > Hi all, > > I recently ran a couple of tests where I took one of my production > systems and did a drop-in replacement of postgres 8.4 with 9.2.4. > I was expecting to see some performance improvement given the release > notes describing 9.2 as a

[GENERAL] 9.0 hot standby, consistent recovery state question

Hi. I have Pg 9.0 wal shipping hot standby secondary server. The primary is under constant stream of updates (avg 20 TXID/s). There are many lengthy COPY FROM operations in the primary. After every restart of secondary postgres I observe that it takes a fair amount of time (sometimes few minute

[GENERAL] pg_dump question (exclude schemas)

I want to backup a database but exclude certain schemas with a patter. I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on. Will this work? $pg_dump --exclude-schema='sch_*' this does not seem to exclude all schemas with this pattern ( 'sch_*' ), anything wrong here? than

Re: [GENERAL] pg_dump question (exclude schemas)

On 08/28/2013 12:30 PM, Jay Vee wrote: I want to backup a database but exclude certain schemas with a patter. I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on. Will this work? $pg_dump --exclude-schema='sch_*' this does not seem to exclude all schemas with this pattern

Re: [GENERAL] pg_dump question (exclude schemas)

On Wed, Aug 28, 2013 at 9:30 PM, Jay Vee wrote: > $pg_dump --exclude-schema='sch_*' > > this does not seem to exclude all schemas with this pattern ( 'sch_*' ), > anything wrong here? The option is fine and works for me on 9.2.4, I suspect the could do a clash with the -N (exclude-schema).