Hi,
pgtune could be the thing you're looking for.
http://pgfoundry.org/projects/pgtune/
regards
andreas
RBN wrote:
Can someone suggest some appropriate initial configuration parameters
and shared memory settings for the following hardware?
I'm running Debian on a Dell with 4x6 core
I'm on PostgreSQL 8.3.11 on Debian.
I have a small piece of DDL (alter table title drop column is_target) that
hangs waiting forever. (I've waited hours - it still shows as waiting in
pg_top.) I have restarted the database - even tried it in single-user mode
- but it still waits.
When I execute
Excerpts from Matthew Excell's message of lun jun 07 15:33:27 -0400 2010:
I'm on PostgreSQL 8.3.11 on Debian.
I have a small piece of DDL (alter table title drop column is_target) that
hangs waiting forever. (I've waited hours - it still shows as waiting in
pg_top.) I have restarted the
That did it. Thanks!
Matthew Excell
On Mon, Jun 7, 2010 at 1:46 PM, Alvaro Herrera
alvhe...@commandprompt.comwrote:
Excerpts from Matthew Excell's message of lun jun 07 15:33:27 -0400 2010:
I'm on PostgreSQL 8.3.11 on Debian.
I have a small piece of DDL (alter table title drop column
Hi Kevin,
Thanks for the clarification.
ke...@kevin-desktop:~$ true
ke...@kevin-desktop:~$ echo $?
0
Yes, my OS also has got this executable and is working.
Regards,
Gnanam
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Saturday, June 05, 2010
Hi Florian,
Thanks for the clarification and a link to a post on automated script.
On Jun 5, 2010, at 9:05 , Gnanakumar wrote:
Thanks for your valuable suggestion and a detailed step on common way to
use
PITR. Things are very clear now except that I've some other question in
connection to
Hi Sam,
Thank your sharing this script.
Here's a script to make your backup and rsync it to a remote destination:
#!/bin/bash
echo checkpoint
echo CHECKPOINT; | /local/pkg/bin/psql template1
echo start backup
echo SELECT pg_start_backup('cisoradr:/cis/pgsql/katana7/backup'); |