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 1sEYB7-0025I7-5j for pgsql-admin@arkaria.postgresql.org; Tue, 04 Jun 2024 17:42:34 +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 1sEYB7-001KDm-4N for pgsql-admin@arkaria.postgresql.org; Tue, 04 Jun 2024 17:42:33 +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 1sEYB6-001KDe-Pn for pgsql-admin@lists.postgresql.org; Tue, 04 Jun 2024 17:42:32 +0000 Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sEYB4-003Qze-Bz for pgsql-admin@lists.postgresql.org; Tue, 04 Jun 2024 17:42:31 +0000 Received: by mail-pj1-x102d.google.com with SMTP id 98e67ed59e1d1-2c1a5913777so4742622a91.2 for ; Tue, 04 Jun 2024 10:42:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717522949; x=1718127749; darn=lists.postgresql.org; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=WYWNrzKaGAiH2bwGZA9PhYRRfbbGMmmz3WEADdQ/Hj4=; b=VbWaMlE4fuGgAP3fytLVmKQ2rLwf3JWTP5x352krOy6IOciYtgz/Q5Bf9MUPRmQ6CQ AyKcLRdZ3baWHSBicy/tKAycZxzXXMmU+1l5M2V81r+cSI50dwAefi/0k7XNtp4bcO8j tOWGnM3leGdDku5nF/MhFr0DBnhz4JtmwcFgleC5bgCWNtWXyDiyS5f4oQxjDEi+Eel/ M9bRo1DmRzBlKAEmuiLDjczDX6ZKPY8OU3jW4Gzz7nIhYlMJjM1WGbTto7zegth7q49z poYtqANLsE7mtTv5CQ/IRejmGC+cV1yWT3T/dYBYgvvVqXX3FPyLjLd25bRdSAaedmQ4 oACA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717522949; x=1718127749; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=WYWNrzKaGAiH2bwGZA9PhYRRfbbGMmmz3WEADdQ/Hj4=; b=MDW6XH966lmQwzSufBGJ6xxIg1DtuiLWZFhX5jcOBNL/hK2g9ST3eypgL7UX8vmIyi 4+1eL7ftlZAgNhfsiflyvIRsBqLusBAYiAHUeXoTwdkZ0iRSYq8khG8dGoJ6l+ATWrlD k9BK2AwSYAH+n09paR2cAzcDxKE3GpX71kyV0RDscGITALnliILkis9bKYkvZIux2jkm EuM2iIgXqrP6xTlaLTA3M4q2P5U6o/usdbv2aBlyf8RzdInGmigdM2hfSMO9uPFy9haZ b7vC4Ck4QVriOIC5ri1UAK9Bnnzh8eL9m/fPDPP0lXWUPALv6tQGrauUKxKDZG1Jw0b8 i0ZA== X-Gm-Message-State: AOJu0YzZops8y9Q85oz5gZ1HrQJ/2yBeg0JH3e2PRoSTDWqiKGdXB9TY lfySPUKWX7cfVWhI6xlg8HvXrydv7zWPLhcinz5NZH3db72Ra1M2U8vMaA== X-Google-Smtp-Source: AGHT+IGkvSufi+BZAcEk4WGMd4cSnFwMPJaG2W8vsxfCEOivbub+KlJ5KpD76bfSL6zVMLv/12pqOw== X-Received: by 2002:a17:90a:d782:b0:2c0:15e1:b96b with SMTP id 98e67ed59e1d1-2c27db03cb7mr156178a91.6.1717522948932; Tue, 04 Jun 2024 10:42:28 -0700 (PDT) Received: from smtpclient.apple ([208.28.126.37]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2c1c27ad126sm8368165a91.1.2024.06.04.10.42.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 04 Jun 2024 10:42:28 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable From: Teja Jakkidi Mime-Version: 1.0 (1.0) Date: Tue, 4 Jun 2024 10:42:17 -0700 Subject: pg_dump and restore without indexes Message-Id: <45A8AB37-2C13-465D-9294-85CCA6C81C2D@gmail.com> To: pgsql-admin X-Mailer: iPhone Mail (21F90) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Admins, I am trying to look for an option that can be added in pg_dump command to ig= nore all the indexes when creating the schema dump with data. Is there any such option that can be used in pg_dump? Or in pg_restore?=20 Please help with your inputs. Thanks in advance, J. Teja.=