> Andrew Sullivan wrote:
>
> On Tue, Feb 19, 2008 at 01:47:01PM -0500, Carol Walter wrote:
> > I have to load a very large database. Is there a command that can
> > load data in bulk faster than the copy command does?
>
> No.
>
There was a thread a while back regarding this.
http://archives.post
I've seen this quite a bit lately especially when Vmware is involved.
Over committing the host server is becoming more common and Vmware has
this "balloon" driver which can bring out the Linux oom-killer process.
Check your messages file for "oom-killer". If it's there, Tom's right
and you need to
> From: Tom Lane [mailto:[EMAIL PROTECTED]
>
> "Spiegelberg, Greg" <[EMAIL PROTECTED]> writes:
> > As you can see, it's only providing the key1 column and the
> sequence is
> > providing the value for the column with the constraint.
> How can t
List,
We're using 8.2.1 in RedHat ES 4 here and I have a simple two column
table: data_keys1.
Table "public.data_keys1"
Column | Type |Modifiers
++--
---
id | bigint | no
See contrib/dblink. It may be able to help.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 10:00 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Copying schemas
Kevin Kempter sayeth...
>
> Hi List;
>
> Anyone have any thoughts per which logging method (SYSLOG vs
> STDERR) is the
> better approach ?
>
From looking at 8.2.1 source the internal postgres stderr redirect
method only does line buffering which explains why we see a performance
gain when we
We have done this here and it works well. In our case we have two
different rev's of PostgreSQL which we install as /path/to/pgsql-7.4.6
and /path/to/pgsql-8.1.3 but reference using links /path/to/pgsql-7.4
and /path/to/pgsql-8.1. Reason is you don't want to muck with your path
every time you upg
Title: Re: FW: [ADMIN] Setting up of PITR system.
You should implement
filesystem or volume level snapshots. LVM, Veritas and the like all have
the functionality and it gets the database out of "backup" mode
quickly.
http://www.tldp.org/HOWTO/LVM-HOWTO/snapshots_backup.html
Before th
onization software
so keep the two in step on the two node's and when you're ready for
backups break the sync process, and backup the "copy". However, pg_dump
isn't that painful and PITR has evolved.
Greg
-Original Message-
From: Chris Travers [mailto:[EMAIL PROT
This is possible. Below is a brief recipe.
1. Use Veritas Storage Foundation HA with Cluster File System.
2. Have a volume with cfs available to 2 or more systems via SAN.
3. Install PostgreSQL and be sure PGDATA is on the cfs mount
4. Create a Storage Checkpoint of cfs mount (read-write virtual
Catching up on my email.
Would it be possible to perform a DELETE FROM table WHERE CURRENT OF mycursor?
Is this implemented in Postgres? I'm not seeing in in the manual for 7.4 or 8.
Greg
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff II
Hello,
It's come to our attention that in 14-16 days our OID's will wrap around and
we need some advice. We're running 7.3.5 in our current production and plan
to eventually move to 7.4.6 which we have in testing. Production consists
of one database cluster with 26 databases. All tables are cre
Benig able to exclude tables from dump's would be useful as well.
Greg
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 26, 2004 6:34 PM
To: Bruno Wolff III
Cc: Gourish Singbal; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Pg_dump
Bruno Wolff III <[
CPU may be thottled because it's performing the backup, gzip and split
all at once. May I suggest this.
/home/postgres/postgresql/bin/pg_dump -h --compress=9 -f
dumpfile.gz $1
split --bytes 500m dumpfile.gz dumpfile.gz.
If that takes too long or clobbers the system...
/home/postgres/pos
If the system in question is ...
1. a Linux or *BSD AND
2. has ipchains/iptables/whatever firewall software installed AND
3. the connections in question to be killed are coming in via
port 5432/tcp
then I would think you could temporarily change the firewall configuration
on the system such th
15 matches
Mail list logo
