Recover databases from raw files (only exists the base directory)

Hi. I have been contacted for this interesting issue: on a standalone postgresql 9.4 server someone deleted all PostgreSQL files and directories except the base directory and its content (/var/lib/pgsql/9.4-base/data/base). So, the question is: there is any chance/procedure to recover the data

Re: Migrating Postgresql from Linux x86

Hi. We do that migration from Postgres 9.0 (x86_64, Centos 6) to Postgres 9.6 (power, SUSE Enterprise 12). The best way to us was to do a backup (pg_dump -Fc ...) and restore using several cores (pg_restore -j N ..., where N equals to the cores/jobs to be used). How many jobs launch to restore de

Re: Table and Index bloating

Hi. Can we use pg_repack with standard community edition of postgresql? Yes. and can it be used on the databases with streaming replication? Yes. Best regards. Carlos Martinez On Mon, Nov 27, 2017 at 10:08 AM, Vikas Sharma wrote: > Thank you Stefan for the queries. > > Thanks you C

Re: Table and Index bloating

Hi. You can consider use pg_repack to remove bloat (http://reorg.github.io/pg_repack/) Best regards. Carlos Martinez On Mon, Nov 27, 2017 at 4:17 AM, Stefan Fercot wrote: > Hi, > > You can track that with some monitoring tools like check_pgactivity. The > queries can be found he