Postgres Guru¹s
Do you guys know the procedure to use hardware snapshots (for eg 3par) to
restore postgres database? Is there somewhere I can find good documentation
to do this?
I¹d like to do the following
# put the database in the backup mode
# take an filesystem snap
# get the database out o
On Fri, Aug 27, 2010 at 12:45 PM, jigar shah
wrote:
> Postgres Guru’s
>
> Do you guys know the procedure to use hardware snapshots (for eg 3par) to
> restore postgres database? Is there somewhere I can find good documentation
> to do this?
>
Did you even read the section of the docs on this I sug
Hello:
I have a DB with 90GB in postgre 8.1 and I want to move to another server.
The new server has postgre 8.3 and I don't know if I can use PITR to do the
replication.
thank you very much.
On Sat, 2010-08-28 at 17:25 +0200, David Montoya wrote:
> Hello:
>
>
> I have a DB with 90GB in postgre 8.1 and I want to move to another
> server. The new server has postgre 8.3 and I don't know if I can use
> PITR to do the replication.
You can not.
Use Londiste or Slony.
JD
--
PostgreSQL
On 2010-08-28 17:44, Joshua D. Drake wrote:
On Sat, 2010-08-28 at 17:25 +0200, David Montoya wrote:
Hello:
I have a DB with 90GB in postgre 8.1 and I want to move to another
server. The new server has postgre 8.3 and I don't know if I can use
PITR to do the replication.
You can not.
I have a DB in constant autovacuum waiting mode:
1 S postgres 26262 4617 0 80 0 - 88927 semtim 10:19 ?00:00:00
postgres: autovacuum worker process Validation waiting
Running vacuumdb, with and without -f, I get o
Carl Anderson writes:
> Running vacuumdb, with and without -f, I get output with final line:
> vacuumdb: vacuuming of database "Validation" failed: ERROR: failed to
> re-find parent key in index "pg_shdepend_reference_index" for deletion target
> page 380
You should be able to fix that with R
http://www.tomtop.com/ China Wholesale
http://www.tomtop.com/wireless-wifi-network-cctv-ir-waterproof-outdoor-ip-security-camera.html
Wireless IP Camera
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Use-hardware-snapshots-to-restore-postgres-tp2740688p2795381.html
Se
On Sat, Aug 28, 2010 at 12:24 AM, Scott Marlowe wrote:
> On Fri, Aug 27, 2010 at 7:57 PM, jigar shah wrote:
>> Postgres Guru’s
>>
>> Do you guys know the procedure to use hardware snapshots (for eg 3par) to
>> restore postgres database? Is there somewhere I can find good documentation
>> to do t
thanks Scott. i have read and used this article a lot of times before.
in section 24.3.2, step number 3 says
"3. Perform the backup, using any convenient file-system-backup tool such as
tar or cpio. It is neither necessary nor desirable to stop normal operation
of the database while you do this.
On Sat, Aug 28, 2010 at 7:15 PM, jigar shah wrote:
> thanks Scott. i have read and used this article a lot of times before.
>
> in section 24.3.2, step number 3 says
>
> "3. Perform the backup, using any convenient file-system-backup tool such as
> tar or cpio. It is neither necessary nor desirabl
11 matches
Mail list logo
