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
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
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
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
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.
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
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
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
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
"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
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
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
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'
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.
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
15 matches
Mail list logo