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
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
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
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 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
*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
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
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
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
*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!
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
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
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
unsubcribe
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
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 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
-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
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;
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
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
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 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
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.
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
25 matches
Mail list logo
