Question : I backed up a database called app_data, on a 9.3 server, with this basic command: pg_dump -n public […]
Tag: pg-dump
pg_restore: [archiver] did not find magic string in file header: please check the source URL and ensure it is publicly accessible
Question : I have been trying to push a dump file from my local Postgrel DB (which I uploaded into […]
Why postgresql pg_dump exports a view as a table?
Question : I am using PostgreSQL 9.3 pg_dump tool for extracting only the public schema definition using: pg_dump -s -n […]
Postgres 9.3 changes the standard_conforming_strings value
Question : I’m migrating a legacy application’s database from Postgres 8.1 to Postgres 9.3 In order to avoid compatibility issues, […]
postgresql pg_dump out of memory
Question : is it possible to limit somehow usage of resources for pg_dump? The problem is, whole DBase is 775GB […]
How to get lsn(xid) numbers of transactions from WAL file?
Question : I’m looking for a way of getting transactions from WAL files. Basically I need their LSN numbers. (ideally […]
How to use pg_restore in database with different postgis installation (postgis schema location)?
Question : I have database1 where postgis is installed in the public schema. And database2 where postgis is located in […]
Does pg_dump flag -j give performance improvement up to -j 16 or -j 32 or even -j 64?
Question : I am backing up and restoring a large DB (7+TB) … I am using pg_dump -j 8 -Fd […]
pg_dump does not honor -n
Question : I’m using pg_dump (9.2 database), to extract one schema and load this into another database (9.4). well, here’s […]
pg_dump custom archive and create backup date
Question : I have archive file with custom format created by pg_dump. Does it contain the backup creation date? I […]