Re: To take backup of Postgresql Database without large objects

Поиск

Список

Период

Сортировка

От	sivapostgres@yahoo.com
Тема	Re: To take backup of Postgresql Database without large objects
Дата	11 апреля 2025 г. 15:55:40
Msg-id	1477036526.178965.1744376140698@mail.yahoo.com обсуждение
Ответы	Re: To take backup of Postgresql Database without large objects Re: To take backup of Postgresql Database without large objects
Список	pgsql-general

Hello,

Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Windows 10.

Trying to take backup of a database, using pg_dump, where one table contains bytea datatype, which I don't want to include in the backup.

My command was:

"E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U <username> --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6

the backup includes the bytea field also.

I tried with

"E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U <username> -B -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6

also, which also included the bytea field.

What wrong I'm doing? Couldn't figure it out. Any help is appreciated.

Happiness Always
BKR Sivaprakash

В списке pgsql-general по дате отправления: