itishree sukla wrote
> Our application is crashing...
It really does help to be more specific with statements of this nature. In
particular:
1) exactly how many idle connections (and are any of them idle in
transaction)? You ran the queries - provide the numbers reported to you.
2) how many con
Hi all,
Our application is crashing due to lot of idle connection from last 1 month
it is very frequent.
When i checked pg_stat_activity I found below query :SELECT e.typdelim FROM
pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem =
e.oid:
is on idle state number of time.
On 06/17/2014 10:37 AM, Khangelani Gama wrote:
-Original Message-
From: Andres Freund [mailto:and...@2ndquadrant.com]
Sent: Tuesday, June 17, 2014 4:38 PM
To: Tom Lane
Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custo
On 06/17/2014 07:27 AM, Severn, Chris wrote:
unsubcribe
To unsubscribe you need to go here:
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On 17-06-2014 22:44, François Beausoleil wrote:
Le 2014-06-17 à 14:22, Condor a écrit :
I do select array_agg(ids) from x;
in ids I have int and result is :
array_agg
-
{3843,2,3543,33}
I want to access one element or first one direct in sql query like:
select arra
Le 2014-06-17 à 14:22, Condor a écrit :
> I do select array_agg(ids) from x;
> in ids I have int and result is :
>
> array_agg
> -
>{3843,2,3543,33}
>
> I want to access one element or first one direct in sql query like:
>
> select array_agg(ids)[1] from x;
>
> and
Hello,
I wanna ask how I can access array element in array_agg ?
I do select array_agg(ids) from x;
in ids I have int and result is :
array_agg
-
{3843,2,3543,33}
I want to access one element or first one direct in sql query like:
select array_agg(ids)[1] from x;
-Original Message-
From: Andres Freund [mailto:and...@2ndquadrant.com]
Sent: Tuesday, June 17, 2014 4:38 PM
To: Tom Lane
Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of file
, ERROR: missin
On Mon, Jun 16, 2014 at 6:10 PM, sunpeng wrote:
> We have many small size(most fixed size) images, how to store them? There
> are two options:
> 1. Store images in folders, managed by os file system, only store path in
> postgresql
> 2. Store image as bytea in postgresql
> How do you usually store
On Thu, Jun 12, 2014 at 1:01 PM, CS_DBA wrote:
> Hi All;
>
> We would like to setup a hot standby server with a forced delay.
> Is it possible to setup a hot standby based ONLY on WAL shipping and NOT
> use streaming replication?
>
> Thanks in advance
>
>
> --
> Sent via pgsql-general mailing lis
On 2014-06-17 10:25:45 -0400, Tom Lane wrote:
> Alban Hertroys writes:
> > Or just connect your 9.2.4 pg_dump remotely to your 8.4 server.
>
> FWIW, the described behavior sounded like the dump file had gotten
> truncated somewhere along the line. Maybe it's just necessary to
> re-do the transfe
unsubcribe
Alban Hertroys writes:
> Or just connect your 9.2.4 pg_dump remotely to your 8.4 server.
FWIW, the described behavior sounded like the dump file had gotten
truncated somewhere along the line. Maybe it's just necessary to
re-do the transfer of the existing dump file.
rega
On 17 June 2014 14:53, Khangelani Gama wrote:
> This part of the documentation describes how to apply appropriate switches
> to your configure to place the 9.2 install into alternate location:
> http://www.postgresql.org/docs/9.2/static/install-procedure.html
>
> - Thanks very much Ziggy
Hi!
Le 2014-06-17 à 08:31, Oliver a écrit :
> Hi,
> I'm a newbie in postgresql. I've mounted my first postgresql instance, it is
> empty now, only with default postgres DB.
> It is under Linux, with 2 filesystems, one for data and another for archiving
> (I've enabled archiving as it will be f
*From:* pgsql-general-ow...@postgresql.org [mailto:
pgsql-general-ow...@postgresql.org] *On Behalf Of *Ziggy Skalski
*Sent:* Tuesday, June 17, 2014 8:17 PM
*To:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] pg_restore: custom archiver unexpected end of file
, ERROR: missing data for column
Hi,
I'm a newbie in postgresql. I've mounted my first postgresql instance, it
is empty now, only with default postgres DB.
It is under Linux, with 2 filesystems, one for data and another for
archiving (I've enabled archiving as it will be for production).
Could someone recommend me a strategy for b
On 2014-06-17, 8:08 AM, Khangelani Gama wrote:
I keep getting the following error when trying to restore a
database on Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s
working fine for other similar databases.
Hi there,
Did you do the pg_dump usi
I keep getting the following error when trying to restore a database on
Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s working
fine for other similar databases.
Hi there,
Did you do the pg_dump using 9.2 binaries or the 8.4 binaries? It's
recommended that yo
*From:* pgsql-general-ow...@postgresql.org [mailto:
pgsql-general-ow...@postgresql.org] *On Behalf Of *Ziggy Skalski
*Sent:* Tuesday, June 17, 2014 5:43 PM
*To:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] pg_restore: custom archiver unexpected end of file
, ERROR: missing data for column
On 2014-06-17, 5:33 AM, Khangelani Gama wrote:
Hi
I keep getting the following error when trying to restore a database
on Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s
working fine for other similar databases.
And then restoring the database on another se
Hi
I keep getting the following error when trying to restore a database on
Postgres 9.2.4.
I used pg_dump –Fc with no owner from one server (8.4.2). It’s working
fine for other similar databases.
And then restoring the database on another server running on 9.2.4 using
pg_restore –Fc. I ge
On Fri, Jun 13, 2014 at 1:01 AM, CS_DBA wrote:
> Is it possible to setup a hot standby based ONLY on WAL shipping and NOT
> use streaming replication?
If I am not wrong then what you are looking for is Archive Shipping.
Any specific reason why you want to do that?
Anyways, you can use pg_rece
As pointed out you may want to look at some of your kernel parameters which
control the writeback (from cache) to disk.
Additionally you may want to take a look bg write parameters. Specially
bgwriter delay. I guess tuning that should help as well.
It might be useful if you can share your paramet
På tirsdag 17. juni 2014 kl. 03:10:57, skrev sunpeng mailto:blueva...@gmail.com>>: We have many small size(most fixed size) images,
how to store them? There are two options:1. Store images in folders, managed by
os file system, only store path in postgresql 2. Store image as bytea in
postgresql
25 matches
Mail list logo