Re: [HACKERS] HELP!!! The WAL Archive is taking up all space

2015-12-08 Thread FattahRozzaq
wrote: > >> On Tue, Dec 8, 2015 at 3:33 AM, FattahRozzaq <ssoor...@gmail.com> wrote: >> >>> Hi all, >>> >>> Please help... >>> >>> I have 1 master PostgreSQL and 1 standby PostgreSQL. >>> Both servers has the same OS Li

[HACKERS] HELP!!! The WAL Archive is taking up all space

2015-12-08 Thread FattahRozzaq
Hi all, Please help... I have 1 master PostgreSQL and 1 standby PostgreSQL. Both servers has the same OS Linux Debian Wheezy, the same hardware. Both server hardware: CPU: 24 cores RAM: 128GB Disk-1: 800GB SAS (for OS, logs, WAL archive directory) Disk-2: 330GB SSD (for PostgreSQL data

[HACKERS] How to import PostgreSQL 9.2.4 dump to PostgreSQL 9.4.5?

2015-10-15 Thread FattahRozzaq
Hi guys, I'm running some test. However, I'm stuck in restoring a PostgreSQL 9.2.4 dump to PostgreSQL 9.4.5 database. I'm doing the backup using pg_dump version PostgreSQL 9.2.4 in text file (SQL dump). I'm trying to restore it to PostgreSQL 9.4.5 usng psql. The restoration error message was