Re: To take backup of Postgresql Database without large objects

On 4/11/25 23:05, David G. Johnston wrote: On Friday, April 11, 2025, Adrian Klaver > wrote: On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wrong or I'm missing something. This w

Re: To take backup of Postgresql Database without large objects

Thanks for the clarification. bytea != large object Happiness Always BKR Sivaprakash On Saturday 12 April, 2025 at 11:36:11 am IST, David G. Johnston wrote: On Friday, April 11, 2025, Adrian Klaver wrote: On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wr

Re: To take backup of Postgresql Database without large objects

On Friday, April 11, 2025, Adrian Klaver wrote: > On 4/11/25 22:06, sivapostg...@yahoo.com wrote: > > Either my command should be wrong or I'm missing something. >> > > This was explained in my post as quoted below. Yeah, the short version. Then you added a long version that just confused the

Re: To take backup of Postgresql Database without large objects

On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wrong or I'm missing something. This was explained in my post as quoted below. Happiness Always BKR Sivaprakash On Friday 11 April, 2025 at 08:31:31 pm IST, Adrian Klaver wrote: On 4/11/25 05:55, sivapostg...

Re: To take backup of Postgresql Database without large objects

> On Apr 11, 2025, at 22:34, sivapostg...@yahoo.com wrote: > Then I've misunderstood large objects. Is there document to explain large > objects? Large objects are a relatively old and now little-used feature of PostgreSQL that predates the bytea type: https://www.postgresql.org/d

Re: To take backup of Postgresql Database without large objects

Thanks.Then I've misunderstood large objects.  Is there document to explain large objects?  We store images in bytea column. Happiness Always BKR Sivaprakash On Saturday 12 April, 2025 at 10:44:21 am IST, David G. Johnston wrote: On Friday, April 11, 2025, sivapostg...@yahoo.com wrot

Re: To take backup of Postgresql Database without large objects

On Friday, April 11, 2025, sivapostg...@yahoo.com wrote: > > > bytea field also included in the backup. > Bytea typed columns are completely separate things than large objects. You cannot exclude individual columns using pg_dump. David J.

Re: To take backup of Postgresql Database without large objects

I tried all the combinations, as mentioned in the documenthttps://www.postgresql.org/docs/current/app-pgdump.html "E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6  "E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U

Re: To take backup of Postgresql Database without large objects

On Fri, Apr 11, 2025 at 8:56 AM sivapostg...@yahoo.com < sivapostg...@yahoo.com> wrote: > Hello, > > Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in > Windows 10. > That's 11 patch releases behind current. > Trying to take backup of a database, using pg_dump, where one table

Re: To take backup of Postgresql Database without large objects

On 4/11/25 05:55, sivapostg...@yahoo.com wrote: 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: "

Re: To take backup of Postgresql Database without large objects

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