No
i have not any dump
Scott Marlowe-2 wrote:
>
> On Fri, Jun 4, 2010 at 10:34 PM, mnavahan wrote:
>>
>> Hi
>>
>> (windows :: pg8.4.4 ::pgadmin 1.10)
>>
>> in old pc i had 3 different tablespace and each tablespace had one
>> database
>>
>> Now i dont have old pc ! but i have copy of each
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 this.
>
>> The correct way to clean out pg_xlog therefore is to either disable WAL
I ran test_fsync on a local ext 3 partition and on a raid jfs SSD array
8x32GB RAID10. The local disk returned quickly and gave what looks like
acceptable results. However, the RAID looks pretty bad. Any one have any
idea why fsync would take so long on an SSD RAID 10.
LOCAL DISK
Simple write
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');" |
/local/pkg/bin/psql template1
echo "rsync"
/local/p
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 CP
