On 31.05.2011 05:16, Tom Lane wrote:
Tomasz Chmielewskiman...@wpkg.org writes:
bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE;
Um ... why are you doing that on a sequence?
ERROR: could not access status of transaction 1573786613
DETAIL: Could not open file pg_clog/05DC: No such file or
On Mon, May 30, 2011 at 1:07 AM, Rabi Jay rabij...@yahoo.com wrote:
When I execute an insert statement, older table records are deleted even
though my insert statement works. It always keeps the maximum number of
records in the table to 4200 records. So If I added 3 more records, it
deletes
sonnix son...@gmail.com wrote:
Can i make only base backup from temporary master to main master?
You didn't say which version of PostgreSQL you're using, what OS
it's running on, how you're managing the replication, or what
exactly you did -- so it's hard to give very specific advice. That
This has happened twice over the last couple of nights:
2011-05-30 02:08:27 PDT LOG: server process (PID 29979) was terminated by
signal 9: Killed
2011-05-30 02:08:27 PDT LOG: terminating any other active server processes
2011-05-30 02:08:31 PDT LOG: all server processes terminated;
Wells Oliver woli...@padres.com wrote:
This has happened twice over the last couple of nights:
2011-05-30 02:08:27 PDT LOG: server process (PID 29979) was
terminated by signal 9: Killed
2011-05-30 02:08:31 PDT FATAL: could not create shared memory
segment: Cannot allocate memory
To
I was wondering if we can query/obtain the high-water mark of number
of sessions or connections reached in a Postgres database. Is there a
view or command that can provide this information. The
pg_stat_database shows the current number of connections, but not the
high-water mark a database
On May 31, 2011, at 11:31 AM, Kevin Grittner wrote:
You're probably overcommitting memory and running afoul of the oom
killer.
You've got an actual 12MB, but you can easily allocate up to
shared_buffers + (user_connections * work_mem), which is 18.5 GB. I
would start by reducing shared_buggers
Wells Oliver woli...@padres.com wrote:
Do you have any recommendations on a pg connection pooler?
If the software you're using includes a connection pool, that is
often the best choice; if not (or it doesn't work well) both pgpool
and pgbouncer have their followings.
In my view the most