I have it set to 0 already.
On Friday 04 October 2013 00:16:28 Ken Brush wrote:
> Try setting the following in your postgresql.conf:
>
> wal_keep_segments = 0
>
> On Thu, Oct 3, 2013 at 2:56 PM, Michal TOMA wrote:
> > Hello,
> >
> > I have a problem on my pg 9.2.4 setup (OpenSuse 12.2, kernel 3.2
On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick wrote:
> 2013/10/4 Jaime Casanova :
>> what version of postgres is this? starting in 9.3 you can create
>> foreign tables between postgres databases, before that you can create
>> a foreing server and use the functions from th dblink module to
>
2013/10/4 Jaime Casanova :
> what version of postgres is this? starting in 9.3 you can create
> foreign tables between postgres databases, before that you can create
> a foreing server and use the functions from th dblink module to
> connect to that server and query the table on it
Read-only forei
Try setting the following in your postgresql.conf:
wal_keep_segments = 0
On Thu, Oct 3, 2013 at 2:56 PM, Michal TOMA wrote:
> Hello,
>
> I have a problem on my pg 9.2.4 setup (OpenSuse 12.2, kernel 3.2.13).
> My pg_xlog directory is growing uncontrolably untill it fills the
> partition. The da
Hello,
I have a problem on my pg 9.2.4 setup (OpenSuse 12.2, kernel 3.2.13).
My pg_xlog directory is growing uncontrolably untill it fills the partition.
The database is under heavy write load and is spread on two tablesapces one on
a ssd software raid1 partition and a second one on a hdd softwa
On 10/3/2013 11:53 AM, bricklen wrote:
Are you uninheriting the partition before attempting to get rid of it?
Eg.
ALTER TABLE your_partition NO INHERIT the_parent_table;
in a completely different but similar scenario, we've tried this, but NO
INHERIT also blocks and and can deadlock if there's
On Thu, 2013-10-03 at 11:53 -0700, bricklen wrote:
>
> On Thu, Oct 3, 2013 at 11:48 AM, Michael Graham
> wrote:
> Hi all,
>
> We partition the data in postgres in a per-month basis and run
> a script
> to delete old partitions.
>
>
> Does "delete" = "dr
On Thu, Oct 3, 2013 at 11:48 AM, Michael Graham wrote:
> Hi all,
>
> We partition the data in postgres in a per-month basis and run a script
> to delete old partitions.
Does "delete" = "drop"?
> Sometimes this script fails and the delete
> doesn't happen because of a deadlock, today I notice
Hi all,
We partition the data in postgres in a per-month basis and run a script
to delete old partitions. Sometimes this script fails and the delete
doesn't happen because of a deadlock, today I noticed that it was the
autovacuumer that fighting with the script.
Is it possible to stop the autova
Thanks for all suggestions. based on the constraints I had with network, I
could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle.
2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file
"000101F60003" from archive
sc
-- Forwarded message --
> From: Shahzad Bashir
> Date: Thu, Oct 3, 2013 at 5:43 AM
> Subject: RE: [ADMIN] Database replication to 50-80 nodes
> To: Jaime Casanova
>
>
> hi,
> I am very much new to postgres, infact just started... can anyone please share
> whats and what not of pos
Alvaro Herrera writes:
> Multiline SQL commands are not supported? Well that sucks, because only
> BUFSIZ chars are read from each line. In my platform that's 8192, but
> maybe in Simeó's case it's shorter .. or maybe his query really is
> longer than 8192 bytes.
> This smells like a pgbench b
Giuseppe Broccolo wrote:
> The format of the script file has to be one SQL command per line;
> multiline SQL commands are not supported, and empty lines are
> ignored. This could bring to errors. Could this be your case?
Multiline SQL commands are not supported? Well that sucks, because only
BUF
On 10/03/2013 07:48 AM, Simeó Reig wrote:
A 2013-10-03 16:40, Adrian Klaver escrigué:
On 10/03/2013 07:23 AM, Simeó Reig wrote:
Unfortunately I can't put the sql here, but I repeat: I could do:
psql -d databasename > scrip_file.sql
and it works perfectly, and It is a one line query.
I wo
Thanks a lot,It worked for me.
Thanks & Regards,
Saritha
On Thu, Oct 3, 2013 at 6:40 PM, David Johnston wrote:
> saritha N wrote
> > ERROR: invalid value "{0" for "dd"
> > DETAIL: Value must be an integer.
>
> The leading "{" in the data is the big give away. This is how a string
> represe
Il 03/10/2013 16:11, Simeó Reig ha scritto:
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long
queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Cl
A 2013-10-03 16:40, Adrian Klaver escrigué:
On 10/03/2013 07:23 AM, Simeó Reig wrote:
You have not shown the query, but could you be running into the
belwo:
http://www.postgresql.org/docs/9.3/interactive/pgbench.html
"The format of a script file is one SQL command per line; multiline
SQL c
On Thu, Oct 3, 2013 at 1:50 AM, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
> How to know cpu and memory utilization in postgres.
>
> We require this information to show it on our Application using any
> postgres command or tool.
>
pg_activity works pretty well:
https://github.
On 10/03/2013 07:23 AM, Simeó Reig wrote:
You have not shown the query, but could you be running into the belwo:
http://www.postgresql.org/docs/9.3/interactive/pgbench.html
"The format of a script file is one SQL command per line; multiline
SQL commands are not supported. Empty lines and line
A 2013-10-03 16:16, Adrian Klaver escrigué:
On 10/03/2013 07:11 AM, Simeó Reig wrote:
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long
queries
and I have the next error:
$ pgbenc
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long
queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client 0 aborted in state 0: ERROR: syntax err
On 10/03/2013 07:11 AM, Simeó Reig wrote:
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client 0 aborted in state 0: ERROR: syntax error at end of input
LINE 1: ...(abc.persones.p
Hello
I was doing a performance test with pgbench with a pretty long queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client 0 aborted in state 0: ERROR: syntax error at end of input
LINE 1: ...(abc.persones.provincia = abc.poblacions.cod_provinc
^
tran
saritha N wrote
> ERROR: invalid value "{0" for "dd"
> DETAIL: Value must be an integer.
The leading "{" in the data is the big give away. This is how a string
representation of an array looks. From the documentation:
http://www.postgresql.org/docs/9.3/interactive/functions-xml.html
> The
Johann Spies wrote:
SELECT A.article_id, A publication_year
You are missing a "." between in what you think is the second
column (after the "A").
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/p
Hello,
I am dealing with the old decision about hiw to store data objects and
trying to understand deep the postgre system including toast,
pg-largedataobject table and so on.
My real doubt right now is why bytea does not gets processed by toast
system even when is grow enough. Since ive read tha
On 10/3/2013 1:50 AM, M Tarkeshwar Rao wrote:
How to know cpu and memory utilization in postgres.
We require this information to show it on our Application using any
postgres command or tool.
the CPU usage would be the total of CPU used by the various postgres
server processes. accurate
Hello Friends,
How to know cpu and memory utilization in postgres.
We require this information to show it on our Application using any postgres
command or tool.
Regards
Tarkeshwar
Johann Spies wrote:
> SELECT A.article_id, A publication_year
>
> I have seen it once before and could not figured out what is causing it.
The point is the missing point between A and publication_year ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
u
Sorry for waisting your time. I just now saw the missing period between A
and publication_year which is causing the problem and explains the
'strange' result.
Regards
Johann
On 3 October 2013 10:08, Johann Spies wrote:
> The table definition:
>
> CREATE TABLE isi.isi_l1_publication
> (
> ar
The table definition:
CREATE TABLE isi.isi_l1_publication
(
article_id character varying(15),
journal_id character varying(7),
volume character varying(10),
issue character varying(10),
publication_year character varying(4),
publication_date character varying(20),
id bigint NOT NULL
Hi,
I am getting an error while retrieving the values from xml and converting
into date format
when I execute this query
select history from KM_REL_FF_USR_DATA whereUSERID in (53008) and
SHARE_WORKING_GROUP =15683
output is
" Enter what you
want to achieve from this programme:
"
from th
33 matches
Mail list logo
