Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3ERf-00CZrX-HE for pgsql-general@arkaria.postgresql.org; Fri, 11 Apr 2025 13:29:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u3ERd-009iFd-Ti for pgsql-general@arkaria.postgresql.org; Fri, 11 Apr 2025 13:29:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3ERd-009iEn-H9 for pgsql-general@lists.postgresql.org; Fri, 11 Apr 2025 13:29:21 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u3ERc-004F8z-0X for pgsql-general@postgresql.org; Fri, 11 Apr 2025 13:29:20 +0000 Received: by mail-oi1-x233.google.com with SMTP id 5614622812f47-3f9a7cbc8f1so626704b6e.0 for ; Fri, 11 Apr 2025 06:29:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744378159; x=1744982959; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=MoH8fIJ2S7kE5k6ugkHqQkiaHHkHVhIr4cpFr49bsrk=; b=SoHlHBTx1KZwOzM7n8OCNQMIjnFE1B8ZqmVIusDZ1pT8HhZCQEcWg9ke1jy/Ebnz65 CvvY/nb5U2jRMo/b8GHQ/wMEzyNTdluH6NU8Nd8l8DqoQ+BRFcm9ynlEBWHbX46QMs8V anVzkuB8SfojcF2f43doW6FSsTl4B4E6IeL/2jDvcfdgEAb7e5x101zbA2+SFO8ls2yX mg6+wZY6J5w4fNLO1tHTngbduspUiiTaFWXl+2oLQWUK7VhWUxmWR9YxXw2CRTgxwUFS 2DCjPu8AwgYbK4nMvG7d3zHC8bmC3WPI49HCZHidfsU4t6hIj26z96QL6C8eNk9GwrXO 3cyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744378159; x=1744982959; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=MoH8fIJ2S7kE5k6ugkHqQkiaHHkHVhIr4cpFr49bsrk=; b=EFwSUI+RJVvZ/TYtYwLkdCixjC8WBUiEQoE+vBCesDickTAyOVr4Tp5UqwxrgE/7DY wRHuvXpHxbptCIZqvMxpkbtUgZYZisd+Bpnvh6wA91oJ/7THYo+TkCatMEOR89exxa9j Fk7iJkC9nHgWsH1egWoOza+GzxgDBTVED0MVzDhdPQm52udhVBIqqK3TsTFHowOjCNpE ABewIqKMQ1w4k+0gc8wxI2H2t/AX26xaJ+sZwGt+Ej/JLctXFXo4y9DuVieY7EdLmY3n WdwfJkDlroenwOPensR/+gqRwgYdzv7G5pyjk98r/NdJW+Urv/HPNhdgXJ3oH6UeVIR+ Xi0w== X-Gm-Message-State: AOJu0YyfKsSiOsHN43fOPuyaaysryTMi5CjahnGiYdXkl1sJ33HxQI0J lTpyAf+G3B05bhfYb5AoJztG8KbaF3yhq5cmgcToAuwEDNIo1W9qQK0AJBXdgEp+cTO4fBZtYI2 lBfH9C5rzx0rqCjQrsdNCi9pl2GcKb6lB X-Gm-Gg: ASbGncs0HCTQUtVHzvCxdT8NLxUu9PbBbtIJ7WiqLiP2SJuWvgTuE0At2n4mywua2OP A3hI07y4qFyyF9cP+mG1DQ8AQOkJe5mBjcM1lDdQaFVXkcR2SP3H1o3kLqYHql6Mv0pf9g6G9JG YngB/RXo+/UXHklx+p0lfLrW1UcQ7/1/mq4wEPkeKTP02CwLx67xeSD2gO X-Google-Smtp-Source: AGHT+IFmFSqevm/jBz02/qSOaUwXkGMkXfBovA8CyOfbyDyIVUldKjKaaSFXVC/ZDMU6fDMLGTLEoKN9gzT4pTCSELg= X-Received: by 2002:a05:6808:384c:b0:3f6:6a86:d0ce with SMTP id 5614622812f47-400850149c7mr1600574b6e.2.1744378158908; Fri, 11 Apr 2025 06:29:18 -0700 (PDT) MIME-Version: 1.0 References: <1477036526.178965.1744376140698.ref@mail.yahoo.com> <1477036526.178965.1744376140698@mail.yahoo.com> In-Reply-To: <1477036526.178965.1744376140698@mail.yahoo.com> From: Ron Johnson Date: Fri, 11 Apr 2025 09:29:07 -0400 X-Gm-Features: ATxdqUHmRFiF1pyptAia2y5gUbWuzUHlhG1f9Rqfh5pvONtqOJyeyaria_ElWLE Message-ID: Subject: Re: To take backup of Postgresql Database without large objects To: Pgsql-general Content-Type: multipart/alternative; boundary="000000000000840f87063280b05b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000840f87063280b05b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Apr 11, 2025 at 8:56=E2=80=AFAM sivapostgres@yahoo.com < sivapostgres@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 > 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 > --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 -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. > The manual explicitly states what you're doing wrong. https://www.postgresql.org/docs/15/app-pgdump.html --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000840f87063280b05b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Apr 11, 2025 at 8:56=E2=80=AFAM <= a href=3D"mailto:sivapostgres@yahoo.com">sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote= :
Hello,

Using=C2= =A0PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Wind= ows 10.

That's= 11 patch releases behind current.
=C2=A0
Trying to take backup of a database, using pg_dump, where one table cont= ains bytea datatype, which I don't want to include in the backup.
=

My command was:
"E:\DBBackup\bin\pg_dump.exe"=C2=A0 -h 192.168.1.1= -p 5432 -U <username> --no-blobs -F c -v -f "E:\DBBackup\demo6_= 110420251637.bak" demo6=C2=A0
<= br>
the backup includes the bytea field also.= =C2=A0=C2=A0

I tried with= =C2=A0
"E:\DBBackup\bin\pg_dump.exe"=C2=A0 -h 192.168.1.= 1 -p 5432 -U <username> -B -F c -v -f "E:\DBBackup\demo6_1104202= 51637.bak" demo6=C2=A0

also, which also = included the bytea field.

= What wrong I'm doing?=C2=A0 Couldn't figure it out.=C2=A0 =C2=A0Any= help is appreciated.

The manua= l explicitly=C2=A0states what you're doing wrong.

--
Death to <Redacted>, and butter sauce.
Don&#= 39;t boil me, I'm still alive.
<Redacted> lobster!
--000000000000840f87063280b05b--