Does your controller support odd number RAID-10 i.e. RAID 1E? If so
then 3 disks in RAID-1E. Or better 10 disks in 1E
On Tue, Aug 27, 2013 at 4:33 PM, Rene Romero Benavides
rene.romer...@gmail.com wrote:
Thanks for your attention.
What would you choose for a postgresql installation: 3 disks
On Tue, Aug 27, 2013 at 7:18 PM, Rene Romero Benavides
rene.romer...@gmail.com wrote:
First of all, thank you so much for your valuable time.
It probably does, though we have a requirement of having available at least
twice the expected database size, and 50% of disk space overhead sounds like
On Tue, Jun 11, 2013 at 2:57 PM, Alejandro Brust
alejand...@pasteleros.org.ar wrote:
Hello, excuse my English first
we recently move from pg9.0 to pg 9.2 whit this method:
from a new server PG9.2 we did:
pg_dump -h server -p 5432 -U user -Fc -i -b base-name bk.backup
after that in the new
On Mon, May 6, 2013 at 2:20 PM, Thomas Kellerer spam_ea...@gmx.net wrote:
I personally don't really care, but what I really find annoying are bottom
posters
that do not trim the quoted message - especially if the original message was
quite long.
Especially if there are dozens of untrimmed
On Mon, May 6, 2013 at 5:16 PM, Misa Simic misa.si...@gmail.com wrote:
But, IMO it is something totally irrelevant now-days... With today tools...
I understand why such thing has been important 20-30 years ago (in previous
century)
You're assuming we all use the same tools. There are still
Does this behavior only affect the 9.2 branch? Or was it ported to 9.1 or
9.0 or 8.4 as well?
On Thu, Apr 11, 2013 at 7:48 PM, Kevin Grittner kgri...@ymail.com wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
However I've got to say that both of those side-effects of
exclusive-lock abandonment
My experience is that you're best off either with a swap space that matches
or exceeds physical memory, or none at all. The linux kernel swap daemon
(kswapd) gets confused and behaves badly with small swap spaces, especially
the more memory you have. Good news is that hard drives are cheap and 32G
12, 2013 at 6:15 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
The really messed up bit is that the problems with the kswapd won't show
up
for weeks, months, or sometimes even longer. The symptoms of a kswapd
problem is that swap is mostly full, but there's LOTS of free memory /
kernel
On Thu, Feb 28, 2013 at 7:21 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Daniel Paval d...@scorpionsoftware.ro writes:
We're dealing with the following situation (PG version is 7.4.30):
7.4? I sure hope you're going to migrate onto something less obsolete
once you get out of this problem. In any
On Wed, Nov 28, 2012 at 11:58 AM, Gabriel Muñoz gabriel.mu...@gmail.com wrote:
As I can give you full permission to a user in a database. For everything
you have that database and the objects to be created in the future.
This means you can access all the schemes, all tables, views, functions,
On Sat, Nov 24, 2012 at 7:25 AM, Subhasis Bhattacharya
subhasis.bhattacha...@gmail.com wrote:
Thanks Craig,
We have plans to upgrade to a later version of postgres, but that could take
a while.
Meantime, I wanted to understand whether the autovacuum failure could be
linked to the fact that
latest is 8.3.21 according to postgresql.org.
On Tue, Nov 27, 2012 at 10:05 PM, subhasis.bhattacha...@gmail.com wrote:
Hi Scott,
Thanks for ur reply. BTW I thought 8.3.14 was the latest in the 8.3
series...no?
--Original Message--
From: Scott Marlowe
To: Subhasis Bhattacharya
On Wed, Nov 14, 2012 at 3:51 PM, Fernando Hevia fhe...@gmail.com wrote:
On Wed, Nov 14, 2012 at 2:30 AM, Aaron Bono aaron.b...@aranya.com wrote:
On our old server, our hosting company said the server was running out of
RAM and then became unresponsive. I haven't checked about the new
On Thu, Oct 18, 2012 at 2:03 AM, teyking2003 tchongk...@hotmail.com wrote:
i'm a very fresh on psql+linux setup.
at my side, i have linux ubuntu 2.6.22-14 server + psql 8.2.5+bluedragon web
server. im confuse with vacuum steps, normally i use
You really should look at updating to a later
On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 tchongk...@hotmail.com wrote:
Can anyone provide me a sample of auto vacuum and also step by step to
configure it inside my linux ubuntu server?
Here's the basic instructions on autovacuum for pgsql 8.2. Note that
since it's out of support, if you
On Fri, Oct 19, 2012 at 1:14 AM, Shams Khan shams.kha...@gmail.com wrote:
Hi Experts,
I am new to postgresql, just wanted to know more about user creation.
I tried to create users using command [create user sam] without any option]
what are the default rights given to the user?
radius=
On Fri, Oct 19, 2012 at 11:49 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 tchongk...@hotmail.com wrote:
Can anyone provide me a sample of auto vacuum and also step by step to
configure it inside my linux ubuntu server?
Here's the basic
On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont
vinc...@searidgetech.com wrote:
Hi,
I'm using Postgresql 9.1.3 x64 on Windows 2008,
I'm doing reliability tests and effects and consequences of a server power
failure.
If you're looking to test for reliability and bugginess, I'd highly
On Mon, Aug 13, 2012 at 8:18 AM, Richard Harper drrwhar...@gmail.com wrote:
All of the databases appear to be where they should be. As an experiment, I
tried tcp/ip to the 'posgres' database. That worked. Thanks to Ray, I
worked that out. Per the suggestion I tried:
psql -h 127.0.0.1 -d
On Fri, Aug 3, 2012 at 12:08 PM, Radovan Jablonovsky
radovan.jablonov...@replicon.com wrote:
Thanks you for your response.
Database config:
shared_buffers = 8GB
temp_buffers = 32MB
work_mem = 64MB
maintenance_work_mem = 512MB
effective_cache_size = 16GB
In usual load there are not much
On Thu, Jul 26, 2012 at 1:31 PM, Gary Webster webs...@lexmark.com wrote:
OK, I set log_statement = all
The log grew to 1GB in ~minute! It is dominated by this one statement,
which occurs every ~1.4 sec:
update WS_BUNDLE set BUNDLE_DATA = $1 where NODE_ID_HI = $2 and NODE_ID_LO
= $3
On Mon, Jun 25, 2012 at 9:19 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Mike Broers mbro...@gmail.com wrote:
Ultimately the hosting service restored the files that they had
not brought over during their maintenance migration and we started
up ok. So that was a relief.
+1
We
On Fri, Jun 8, 2012 at 1:30 PM, Lonni J Friedman netll...@gmail.com wrote:
I've looked at iostat output both before during pg_basebackup runs,
and I'm not seeing any indication that the problem is due to disk IO
bottlenecks. The numbers don't vary very much at all between the good
bad
Can you run db wide vacuums? That's what I'd try first.
On Fri, May 18, 2012 at 10:41 AM, Little, Douglas
douglas.lit...@orbitz.com wrote:
Hello,
Apologies in advance for asking here and not on the greenplum forum, but
I’m asking here because I think the PG community understands pg better
On Tue, May 8, 2012 at 8:57 AM, Tim Bruce - Postgres
postg...@tbruce.com wrote:
On Tue, May 8, 2012 07:28, Fred Parkinson wrote:
I am currently using postgresql version 9.1.3
In the past, when I ran psql and needed useful information provided by
commands like \h or \d, the information was
I'm assuming this is a reply that has the quoted two deep stuff in it
from the OP to you, Ricardo.
On Thu, Apr 26, 2012 at 5:49 AM, Ricardo Benatti rbena...@gmail.com wrote:
the port is listening in VM ?
netstat -nat
Active Internet connections (servers and established)
Proto Recv-Q
On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver wellsoli...@gmail.com wrote:
Hey all, I have a question about streaming replication available in PG 9+
The general configuration I see is along the lines of this:
On Tue, Mar 20, 2012 at 5:42 PM, Imre Oolberg i...@auul.pri.ee wrote:
Hi!
My comerade has to decide for his so to say generic and a bit unpredicted
PostgreSQL needs for web applications between Intel and AMD based server.
For now it has been coming down to these processor choices
1. Dell
As a followup to my previous post, if you get a solid white box, you
could build a machine for $17k that will beat the two previously
listed machines pretty badly, and in a small form factor as well.
Take one of these:
http://www.aberdeeninc.com/abcatg/mb1661.htm
and throw 4 16C AMDs and 128G
On Wed, Mar 14, 2012 at 5:24 AM, Khangelani Gama kg...@argility.com wrote:
thanks, the issue we have is that we have many Linux users having root
access into the system.
That's the problem right there. Setup a separate db server that only
your DBA can log into the shell on. Then make it so
On Thu, Mar 8, 2012 at 12:23 PM, umashankar narayanan
umashan...@graffiti.net wrote:
Kevin,
The full version of Postgres is 8.3.1. It is running on Microsoft Windows
2003 Standard 32-bit on VMWare.
On the system logs around this time, the only message that we receive is
that the PID crashed.
On Fri, Feb 3, 2012 at 9:44 AM, ajay kumar akp...@hotmail.com wrote:
Dear All ,
Could you please confirm if the Postgres community version can support the
128GB RAM and 4 processors expandable upto 8 processors (each quad core).
Not sure what you mean by community edition. There's
On Sun, Feb 5, 2012 at 9:24 PM, ajay kumar akp...@hotmail.com wrote:
Thanks Scott .
community edition means There is no license fees for using PostGresql as
it is Open Source database .
Cool. I've personally tested and used pgsql machines with 128G of
memory and 4 of the AMD 12 core opteron
On Tue, Jan 24, 2012 at 10:05 PM, Gnanakumar gna...@zoniac.com wrote:
Hi,
Our Production server is running PostgreSQL v8.2.22 on CentOS5.2. Based on
the application usage trend, we're finding that we need to increase maximum
number of concurrent connections to the database server, that is
On Mon, Jan 23, 2012 at 10:21 AM, Andreas Hasenack panli...@gmail.com wrote:
On Fri, Jan 20, 2012 at 16:45, Nicholson, Brad (Toronto, ON, CA)
bnichol...@hp.com wrote:
In the past I've used Slony to upgrade much larger database clusters than
yours with minimal down time (I'm talking seconds
On Tue, Jan 17, 2012 at 12:30 PM, Frank Lanitz fr...@frank.uvena.de wrote:
On Tue, 17 Jan 2012 11:41:13 -0600
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
I'm not sure it is possible to have a public post removed from the
archives;
No, its not. You cannot purge a post from all mirrors
On Thu, Jan 5, 2012 at 7:27 AM, MirrorX mirr...@gmail.com wrote:
thx a lot for your advice. it's true that even under load, i havent seen any
so or si...so probably it's best to let the OS handle the situation.
in the meantime if anyone has any idea why the OS would do such a thing, pls
share
On Tue, Dec 13, 2011 at 1:23 AM, Selva manickaraja mavle...@gmail.com wrote:
Hi All,
We are planning to create a 2nd instance of postgres db in the same server.
The reason is simple. After we added another application, the number of
You don't mention which OS you're running, but any debian
On Mon, Dec 5, 2011 at 1:18 PM, Yann ROBIN me.s...@gmail.com wrote:
First things first: Before you do anything else, shut down
PostgreSQL and make a copy of the data directory tree.
http://wiki.postgresql.org/wiki/Corruption
Did it.
Second, please post information about your environment.
On Mon, Dec 5, 2011 at 1:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Mon, Dec 5, 2011 at 1:18 PM, Yann ROBIN me.s...@gmail.com wrote:
kill -9 of the writer process
Are you sure you killed all the postgres backends before restarting
the server
On Fri, Dec 2, 2011 at 2:16 AM, Myint my...@oneempower.com wrote:
Dear admin,
We have installed postgres 9.1 rpm package to red hat
Linux 2.6.18- x86_64 x86_64 x86_64 GNU/Linux. After we setup and install
database we can create data folder on /app/postgres/oe. But when
On Tue, Nov 29, 2011 at 11:15 AM, Craig James
craig_ja...@emolecules.com wrote:
Several times recently one of our databases has gotten stuck with the
following situation:
postgres=# select datname, procpid, usename, current_query from
pg_stat_activity where current_query != 'IDLE';
datname
On Tue, Nov 29, 2011 at 10:57 AM, Kasia Tuszynska ktuszyn...@esri.com wrote:
Postgres:
Begin transaction
Insert - no error
Insert - error raised
Transaction loss = no implicit rollback to the single error free insert.
Is this a correct interpretation of the Postgres transaction error
On Mon, Nov 28, 2011 at 10:11 AM, Lukasz Brodziak
lukasz.brodz...@gmail.com wrote:
Hello,
I have a problem with client's database. When I log into application and
work on the data everything seems fine, but when I try to dumpd the database
connection closes. I have located the faulty table and
On Thu, Nov 10, 2011 at 12:36 AM, Uwe Schroeder u...@oss4u.com wrote:
Hello,
1) what is tablespace in postgres?
2) one more issue is that, I try to rename or delete some file in
/opt/PostgresPlus/9.0/data/base/16428/ directory. when I restart postgres
server, it start normally.
On Thu, Oct 20, 2011 at 12:16 PM, Mark Steben
mark.ste...@autorevenue.com wrote:
Hi all,
I'm evaluating the check_postgres program. We are running postgres 8.3.
Does anybody have any experience with this monitoring software they would
like to share? I'm specifically interested in the
I use it as both a nagios plugin and standalone.
On Thu, Oct 20, 2011 at 2:14 PM, Mark Steben
mark.ste...@autorevenue.com wrote:
Thanks Scott - do you ship the output to Nagios?
On Thu, Oct 20, 2011 at 4:10 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Thu, Oct 20, 2011 at 12:16 PM
On Mon, Oct 10, 2011 at 11:17 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
And normal maintenance may be viewing newer data as old, due to
transaction wrap-around from the old pg_control file, and removing
it as part of normal cleanup. So you may have destroyed some of
your more
On Mon, Oct 10, 2011 at 1:13 PM, Akash Kodibail
akash.kodib...@onmobile.com wrote:
I was hopeful of restoring the data from data files in $PGDATA path. I read
this article about PITR using the recovery.conf, But I am not aware of the
pre-requisites and not entirely sure about the concept
On Tue, Oct 4, 2011 at 12:28 PM, Kevin Ricords ke...@silverback.com wrote:
Thank you for your response. I believe I misunderstood reclaimed for
re-use. Using contrib/pg_freespace, I see empty index pages can be reused
elsewhere in the same index, but are not deallocated. To keep my index at
On Fri, Sep 23, 2011 at 1:23 PM, Joe Conway m...@joeconway.com wrote:
On 09/23/2011 12:02 PM, Burgholzer, Robert (DEQ) wrote:
I am trying to get my head around why I keep getting crashes to my PG
8.3.7 database on CentOS - Linux version 2.6.18-164.el5. There are 3
slightly different (I think)
On Fri, Sep 23, 2011 at 1:38 PM, Burgholzer, Robert (DEQ)
robert.burghol...@deq.virginia.gov wrote:
Joe,
Thanks - I will try to check into this - however, we have done some tuning
on the memory over the last 2 years and gotten it such that it is seldom if
every having to dip into its swap too
On Fri, Sep 23, 2011 at 2:45 PM, Burgholzer, Robert (DEQ)
robert.burghol...@deq.virginia.gov wrote:
Scott - thanks, in pouring over the logs, I have not found anything certain,
but have turned up a ton of mesages about my sysadmins se-linux security and
php/pg (don't know if they're my app or
PGDATA=/raid/PostgreSQL/data
LESSOPEN=| /usr/bin/lesspipe %s
LESSCLOSE=/usr/bin/lesspipe %s %s
_=/usr/bin/env
To make top/vi work, I just need to unset LD_LIBRARY_PATH.
于2011年9月18日 13:31:45,Scott Marlowe写到:
2011/9/17 Rural Hunterruralhun...@gmail.com:
I installed pgsql 9.1 on Ubuntu server
On Sun, Sep 18, 2011 at 8:00 PM, Rural Hunter ruralhun...@gmail.com wrote:
Well, I installed pg by the official one-click graphic
installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh, when
I tried to get an error message if I don't set LD_LIBRARY_PATH, I found it's
now
On Tue, Nov 30, 2010 at 10:37 AM, 100-eti 100-...@csc-scc.gc.ca wrote:
There was no server log anywhere, there were no entries in the Event Viewer
(under Application, Security or System) and I ensured the entire directory
structure is set to Full Control for the user (and the user is in the
2011/9/17 Rural Hunter ruralhun...@gmail.com:
I installed pgsql 9.1 on Ubuntu server(10.10). Now I have a problem with the
required env variable LD_LIBRARY_PATH. If I do not set this, I can not use
some pg tools such as pg_dump, createuser...etc. If I set this variable, my
term gets warning
On Tue, Sep 6, 2011 at 3:06 PM, MirrorX mirr...@gmail.com wrote:
hello to all
i am stuck in the following situation. i have a table which is 500GB. due to
some deleted rows the actual size is about 350-400GB and i would like to
reclaim that disk space since from now on this table will remain
On Fri, Sep 2, 2011 at 9:30 PM, Rural Hunter ruralhun...@gmail.com wrote:
Hi Kevin,
I did another try with following additional changes based on our discussion:
1. use the tcp connection
2. turn off autovacuum
3. turn off full_page_writes
I could import more than 30G data in about 2 hours.
On Thu, Sep 1, 2011 at 7:48 AM, Campbell, Lance la...@illinois.edu wrote:
Postgres 9.0.4
I installed from the visual linux installer
Redhat 6 newest updates
I reinstalled postgres from scratch receintly. I recreated a role with
createrole called XYZ. I do not want XYZ to use a password on
2011/8/29 Rural Hunter ruralhun...@gmail.com:
Hi all,
I'm a newbie here. I'm trying to test pgsql with my mysql data. If the
performance is good, I will migrate from mysql to pgsql.
I installed pgsql 9.1rc on my Ubuntu server. I'm trying to import a large
sql file dumped from mysql into pgsql
On Thu, Aug 25, 2011 at 7:17 AM, Igor Neyman iney...@perceptron.com wrote:
-Original Message-
From: Florian Weimer [mailto:fwei...@bfk.de]
Sent: Wednesday, August 24, 2011 5:00 AM
To: Gabriele Bartolini
Cc: pgsql-admin@postgresql.org
Subject: Re: Database alias
* Gabriele
2011/8/16 s...@bestmx.ru s...@bestmx.ru:
Scott Marlowe пишет:
On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.rus...@bestmx.ru wrote:
Scott Marlowe пишет:
On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.com
wrote:
Dear Postgres users,
from last few months I am reading
On Tue, Aug 16, 2011 at 12:25 PM, Merlin Moncure mmonc...@gmail.com wrote:
one point that is getting lost in all this that if you are using a
database for an application server, this does not mean it's the same
database as your main database or even on the same machine -- you can
still keep
On Sat, Aug 13, 2011 at 9:57 AM, c k shreeseva.learn...@gmail.com wrote:
Dear Postgres users,
from last few months I am reading and searching for can postgresql used as
application server? As postgresql supports many languages like pl/perl,
Besides the previously mentioned nginx module there's
On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.ru s...@bestmx.ru wrote:
Scott Marlowe пишет:
On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.com wrote:
Dear Postgres users,
from last few months I am reading and searching for can postgresql used
as
application server
On Wed, Aug 10, 2011 at 1:23 AM, c k shreeseva.learn...@gmail.com wrote:
When I try to re-execute it, it says 'no connection to the server'. When
checked the logs I found
2011-08-09 19:46:00 IST LOG: database system was interrupted; last known up
at 2011-08-09 19:45:17 IST
2011-08-09
On Wed, Aug 3, 2011 at 7:30 AM, ALEXANDER JOSE aang...@hotmail.com wrote:
Good morning,
I have a postgres database on a server v 8.2.5 windows, and I need to
install the postgres version 8.2.5 on Server with Suse Linux Enterprise but
does not create 860 functions, let me know if have
On Thu, Jul 21, 2011 at 6:08 PM, Juan Cuervo (Quality Telecom)
juanrcue...@quality-telecom.net wrote:
Hi All
I'm new to the list, but have a few years as postgres user. I want to share
what I consider a rare behavior of postgresql regarding database object's
premissions:
I have noticed that
On Fri, Jul 15, 2011 at 2:09 AM, lst_ho...@kwsoft.de wrote:
Zitat von Kevin Grittner kevin.gritt...@wicourts.gov:
Jenish Vyas jenishv...@gmail.com wrote:
I am able to insert 1190- 1210 records per seconds.
Now I just want to know by what extend I could stretch it.
What is the maximum
On Fri, Jul 15, 2011 at 3:39 AM, Scott Marlowe scott.marl...@gmail.com wrote:
System: SuperMicro H8QG6
4xAMD Opteron(tm) Processor 6168
Total 48 cores
128G RAM
Areca 1680 w 512M battery backed cache
32 15k SAS 147Gig drives
pgbench -i -s 100
pgbench -c 48 -t 1
tps = .626762
On Fri, Jul 15, 2011 at 1:11 AM, saravanan saravanan.k...@gmail.com wrote:
Hi,
I tried to troubleshoot the errors while importing dumps in PostgreSQL -
8.0.0 version. But still i'm getting some permission level errors. Before
importing the dumps, i used to install some functions like
2011/7/14 Christoph Anton Mitterer
christoph.anton.mitte...@physik.uni-muenchen.de:
Hi.
I've read through the documentation and while I've seen dozens of
options which allow to set which kind of buffer/cache/shared-mem gets
how big... I do not quite understand how to reach the following.
On Mon, Jun 13, 2011 at 10:29 AM, Dinesh Bhandary dbhand...@iii.com wrote:
Hi All -
Is there a way to change work_mem for a session in postgres without
restarting a database? Please let me know.
In addition the standard set work_mem='512MB'; listed above, you can
make such changes sticky for
On Sun, May 29, 2011 at 6:07 PM, Rabi Jay rabij...@yahoo.com wrote:
Hi,
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
On Fri, May 20, 2011 at 3:14 PM, Craig James craig_ja...@emolecules.com wrote:
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I can't figure out what. The two production servers, which
are essentially identical, don't show these symptoms. In a nutshell,
On Wed, May 18, 2011 at 9:19 AM, Florian Weimer fwei...@bfk.de wrote:
I've run two CREATE INDEX CONCURRENTLY on the same table in parallel,
and one of them errored out with:
The curious thing is that both indexes were created. I would have
expected that the creation of idx1 would be rolled
On Wed, May 4, 2011 at 10:48 AM, Mark Stosberg m...@summersault.com wrote:
5. Finally, I'll drop the indexes on the parent table and
truncate it.
Luckily I noticed the problem with TRUNCATE and partitioning before my
work got to production.
TRUNCATE cascades automatically and silently to
On Wed, May 4, 2011 at 11:04 AM, Mark Stosberg m...@summersault.com wrote:
It is not as findable as it could be then. Besides scanning the page, I
also searched for child, parent and partition, and none of those
words are mentioned. Neither is inherit. Pulling out ONLY to have
it's own
On Wed, May 4, 2011 at 12:37 PM, Tomasz Chmielewski man...@wpkg.org wrote:
/var/log/postgresql/postgresql_log.1:May 3 18:24:49 db10 postgres[21363]:
[26999-1] 2011-05-03 18:24:49 SGT ERROR: could not access status of
transaction 1573786613
/var/log/postgresql/postgresql_log.1-May 3
I had a similar problem about a year ago, The parent table had about
1.5B rows each with a unique ID from a bigserial. My approach was to
create all the child tables needed for the past and the next month or
so. Then, I simple did something like:
begin;
insert into table select * from only
On Wed, Apr 27, 2011 at 6:26 PM, Scott Marlowe scott.marl...@gmail.com wrote:
I had a similar problem about a year ago, The parent table had about
1.5B rows each with a unique ID from a bigserial. My approach was to
create all the child tables needed for the past and the next month or
so
On Tue, Apr 5, 2011 at 5:34 PM, Kasia Tuszynska ktuszyn...@esri.com wrote:
Hello Admin Group:
We are configuring Postgres on Ubuntu (LLynx) and trying to figure out what
is the best way of dealing with swap since, Ubuntu does not automatically
come with swap storage assigned.
Nothing but
On Thu, Apr 7, 2011 at 8:56 AM, French, Martin fren...@cromwell.co.uk wrote:
Thanks for the info Tom.
The table has been analyzed (somewhat repeatedly...), with the stats
target set at various limits.
At the moment default_statistics_target = 50.
I've had work_mem as low as 1MB and as high
On Tue, Mar 15, 2011 at 6:50 AM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
Hi all -
Ever since daylight savings time, I've noticed that the timestamp in the log
files on 2 of our many postgres servers (version 8.4.5) did not update.
It's still 1 hour behind. The settings are all
On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
when you say updating postgres - do you mean the server software? How do
you update the tz data?
Yes updating the pg software. The OS has tzdata as well, and you can
update that. But postgresql includes its own
On Tue, Mar 15, 2011 at 12:17 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
when you say updating postgres - do you mean the server software? How do
you update the tz data?
Yes updating the pg software
On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar gna...@zoniac.com wrote:
So, now we've decided to either DROP TABLE pg_temp_xx.FOO or DROP SCHEMA
pg_temp_xx explicitly just before closing the connection (after step 3 and
before step 4), so that it'll not be visible for the next database
connection
On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch ar...@reschab.net wrote:
Hi there,
what options do exist to replicate from a master by schema?
What I'm really after is this scenario:
Say, I have 100 databases out
On Mon, Feb 14, 2011 at 11:05 AM, Bryan Keller brya...@gmail.com wrote:
Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I
a still going to shoot for using iSCSI, given it is a block-level protocol
rather than file-level, it seems to me it would be better suited to
On Thu, Jan 27, 2011 at 9:12 AM, Bruce Momjian br...@momjian.us wrote:
Bernhard Schrader wrote:
Am Donnerstag, den 27.01.2011, 09:18 -0600 schrieb Kevin Grittner:
Bernhard Schrader bernhard.schra...@innogames.de wrote:
what maybe is also interesting, if i start the database manually i
On Sat, Jan 22, 2011 at 2:27 AM, John Lister john.lis...@kickstone.com wrote:
Instead I tried to vacuum them, but this didn't make any difference (or
indeed do anything), so in the end I deleted the tables manually instead,
which instantly reset the transaction count back to the 1billion mark.
On Thu, Jan 20, 2011 at 5:00 AM, French, Martin fren...@cromwell.co.uk wrote:
Having been a C/C++ developer many years before being a DBA, and having
written ITIL software; How is migrating structure from a Development
database to a test database whilst maintaining test data backwards?
It's
On Thu, Jan 20, 2011 at 5:00 AM, French, Martin fren...@cromwell.co.uk wrote:
Personally, I'd rather
not go trawling through what can only be described as hundreds of
thousands of lines of PostgreSQL log to find THE RIGHT DDL statements.
Oh that's easy. Grep out the statements that start
On Thu, Jan 20, 2011 at 8:46 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Thu, Jan 20, 2011 at 5:00 AM, French, Martin fren...@cromwell.co.uk
wrote:
Personally, I'd rather
not go trawling through what can only be described as hundreds of
thousands of lines of PostgreSQL log to find
On Thu, Jan 20, 2011 at 9:53 AM, CS DBA cs_...@consistentstate.com wrote:
Hi All;
I suspect I know the answer to this...
What's the current state of multi-master replication for PostgreSQL? Is
Bucardo the only true master/master solution out there that might be worthy
of a production push?
On Thu, Jan 20, 2011 at 10:42 AM, Bradley Holbrook
operations_brad...@servillian.ca wrote:
Thanks Scott... a couple comments.
Our developers never decide what goes to where... they just happily plumb
away on the development db until we're ready to take our product to testing
(at regular
Followup, note that you can set the log_statement='ddl' for an entire
pg cluster, for a single database, or for a single user, if that
helps. logging ddl does not log dml, or data changes, just structural
changes.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
On Thu, Jan 20, 2011 at 10:52 AM, Scott Marlowe scott.marl...@gmail.com wrote:
Followup, note that you can set the log_statement='ddl' for an entire
pg cluster, for a single database, or for a single user, if that
helps. logging ddl does not log dml, or data changes, just structural
changes
On Thu, Jan 20, 2011 at 6:08 PM, John DeSoi de...@pgedit.com wrote:
On Jan 20, 2011, at 12:42 PM, Bradley Holbrook wrote:
Our developers never decide what goes to where... they just happily plumb
away on the development db until we're ready to take our product to testing
(at regular
1 - 100 of 998 matches
Mail list logo