[GENERAL] pgbench help

2012-12-23 Thread Atri Sharma
Hi all, I have two 9.2 servers running in different data directories and installation directories. One of them(the main one) has its bin in the path of my system.The other one does not, hence, I need to use the complete path(/usr/local/pgsql/...). I want to run pgbench on the second server. How s

Re: [GENERAL] Vacuum analyze verbose output

2012-12-23 Thread Anjali Arora
Please let me know the query to get freepsace associated with all the relations after installation of pg_freespacemap.   Regards, Anjali --- On Wed, 19/12/12, Glyn Astill wrote: From: Glyn Astill Subject: Re: [GENERAL] Vacuum analyze verbose output To: "Anjali Arora" , "pgsql-general@postgres

[GENERAL]

2012-12-23 Thread News Subsystem
Sun, 23 Dec 2012 18:45:11 -0800 (PST) Received: by 10.49.34.135 with SMTP id z7mr3027069qei.1.135631781; Sun, 23 Dec 2012 18:45:11 -0800 (PST) X-Newsgroups: pgsql.general Date: Sun, 23 Dec 2012 18:45:11 -0800 (PST) In-Reply-To: Complaints-To: groups-ab...@google.com Injection-Info: gl

Re: [GENERAL] logger table

2012-12-23 Thread John R Pierce
On 12/23/2012 7:01 PM, Philipp Kraus wrote: I don't know how can I create a good PK value. IMHO a sequence can be create problems that I'm logged in with the same user on multiple hosts, why is that a reason ? sequences work no matter how many clients there are. PK is at the moment jobid

Re: [GENERAL] logger table

2012-12-23 Thread Alejandro Carrillo
Did you use pg_audit? https://github.com/jcasanov/pg_audit > > De: Philipp Kraus >Para: pgsql-general@postgresql.org >Enviado: Domingo 23 de diciembre de 2012 22:01 >Asunto: [GENERAL] logger table > >Hello, > >I need some ideas for creating a PG based logger.

[GENERAL] logger table

2012-12-23 Thread Philipp Kraus
Hello, I need some ideas for creating a PG based logger. I have got a job, which can run more than one time. So the PK is at the moment jobid & cycle number. The inserts in this table are in parallel with the same username from different host (clustering). The user calls in the executable "mypri

Re: [GENERAL] downgrading a database

2012-12-23 Thread Andrew Sullivan
In addition to the other suggestions, you can do this with Slony. It was one of its use cases. A On Sun, Dec 23, 2012 at 06:54:49PM +0200, Heine Ferreira wrote: > Hi > > Is it possible to downgrade a Postgresql database from a > newer to an older version? > If so how do you do it? > Let's assum

Re: [GENERAL] Pipelining INSERTs using libpq

2012-12-23 Thread Merlin Moncure
On Sunday, December 23, 2012, Tom Lane wrote: > Florian Weimer writes: >> Does the wire protocol support pipelining? > > Yes, but libpq doesn't really expose the capability, because it's too > simple-minded to deal with more than one query in flight. > > regards, tom lane

Re: [GENERAL] downgrading a database

2012-12-23 Thread Adrian Klaver
On 12/23/2012 08:54 AM, Heine Ferreira wrote: Hi Is it possible to downgrade a Postgresql database from a newer to an older version? If so how do you do it? Let's assume you are not using any features in the newer version. Say from 9.2 to 9.1. Would need to be done as a test first. I just tri

Re: [GENERAL] Using POSIX Regular Expressions on xml type fields gives inconsistent results

2012-12-23 Thread Tom Lane
"David Johnston" writes: >> while it might work to reverse the order in a regex, I have experienced >> severe slowdown when the pattern comes from table data > If it is indeed related to the custom reverse query the fact that you are > going through an SQL wrapper to access a c-level function is

Re: [GENERAL] Insert Assertion Failed in strcoll_l.c:112

2012-12-23 Thread Tom Lane
Michael Arnold writes: > The following is written to /var/log/postgresql/postgresql-9.1-main.log: > 127.0.0.1(59800) INSERT: strcoll_l.c:112: __strcoll_l: Assertion > `((uintptr_t) > indirect) % __alignof__ (indirect[0]) == 0' failed. This appears to be a failure inside glibc (specifically strc

Re: [GENERAL] Pipelining INSERTs using libpq

2012-12-23 Thread Tom Lane
Florian Weimer writes: > Does the wire protocol support pipelining? Yes, but libpq doesn't really expose the capability, because it's too simple-minded to deal with more than one query in flight. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] downgrading a database

2012-12-23 Thread Andreas Kretschmer
Heine Ferreira wrote: > Hi > > Is it possible to downgrade a Postgresql database from a > newer to an older version? > If so how do you do it? > Let's assume you are not using any features in the > newer version. > Say from 9.2 to 9.1. You can try it with an ascii-dump. Andreas -- Really, I'

[GENERAL] downgrading a database

2012-12-23 Thread Heine Ferreira
Hi Is it possible to downgrade a Postgresql database from a newer to an older version? If so how do you do it? Let's assume you are not using any features in the newer version. Say from 9.2 to 9.1. Thanks H.F.

Re: [GENERAL] Pipelining INSERTs using libpq

2012-12-23 Thread Florian Weimer
On 12/21/2012 03:29 PM, Merlin Moncure wrote: How you attack this problem depends a lot on if all your data you want to insert is available at once or you have to wait for it from some actor on the client side. The purpose of asynchronous API is to allow client side work to continue while the se