python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - pg-dump

pg_dump 0 bytes backup file, stuck after saving database definition

I am trying to backup Postgres database but I always get 0 bytes backup size. If I use the verbose switch, I can see that it is stuck at pg_dump: saving database definition I have tried taking backup...
test-img

Shubham Goel

postgresql

pg-dump

Votes: 0

Answers: 1

Latest Answer

I was able to resolve this. When I was creating the backup, I checked the postgres logs and it was clearly written there that during backup the server wasn't reachable. Now to resolve this, I have add...
test-img

Shubham Goel

Problem with backup / restore a table with a composite data type column

I have a table europa=# \d europa.recurring_payment Table "europa.recurring_payment" Column | Type ...
test-img

Germán C. Basisty

postgresql

pg-dump

Votes: 0

Answers: 1

Latest Answer

Probably your dump does not contain a composite data type definition. Open dump file in a text editor or grep it for composite data type definition command. after creating an empty database The empty...
test-img

Sergey Zaykov

How does the pgadmin encodes the file path in backups?

I'm trying to restore dump files from locations that contain character from other languages besides English. So here is what I did: From inside the pgadmin I used the backup tool like: And inside the...
test-img

Shahar Shokrani

postgresql

encoding

pgadmin

pg-dump

pg-restore

Votes: 0

Answers: 1

Latest Answer

This is not something weird pgadmin does, but rather it is something weird Windows itself does when needing to represent such file names in a DOS-like setting. Like when the name is more than 8 chars...
test-img

jjanes

Posts

Questions

Blogs

Jobs