Am Dienstag, 7. Dezember 2004 03:55 schrieb [EMAIL PROTECTED]:
> I'm considering using the DRBD network block device for a Postgres high
> avilability solution. Does anyone have any experience with this kind of
> setup?
Yes, many people use this kind of setup. It works fine.
--
Peter Eisentraut
Thanks, i think Slony-I might be an answer to my questions. But need
to explore Slony-I before saying anything.
Has Anybody found any dificulties in implementing hotback, using Slony-I.
Thoughts would be of great help.
regards
Gourish.
On 7 Dec 2004 04:17:21 GMT, Christopher Browne <[EMAIL PROTE
Hi all,
I'm a bit unhappy with the time it takes to do backup of my PG7.4.6
base.
I have 13GB under the pg/data dir and it takes 30 minutes to do the
backup.
Using top and iostat I've figured out that the backup job is cpu bound
in the postmaster process. It eats up 95% cpu while the disk is at 10
Title: Running sql files
Hi,
I just wanted to know how to disable the results being displayed on the screen.
When I try the following command -
$psql dbname < sqlfile
The results of the command are displayed on to the screen. In one file I am trying to populate a table with values ( There
Hi,
You could try running the command like this
$psql dbname < sqlfile > /dev/null
I believe this should work fine
Regards
Kevin Izzet
Database / Unix / Linux Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: [EMAIL PROTECTED]
"Pradeepkumar,
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
unsubscribe
--
___Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=signup
Hi Greg & others.
I run this on a 4 cpu smp box (Dell PE6650+EMC AX100) so I already
offload pg_dump, gzip and split to other cpu's. Top confirms this:
postmaster = 95% cpu ie. it uses one cpu completely. Unless I can get
postmaster to do less work (that's what I'm looking for) or run multiple
thre
