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 1qvLIF-004d2d-9v for pgsql-admin@arkaria.postgresql.org; Tue, 24 Oct 2023 17:34:15 +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 1qvLID-00Alpg-1o for pgsql-admin@arkaria.postgresql.org; Tue, 24 Oct 2023 17:34:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvLIC-00Alp2-MZ for pgsql-admin@lists.postgresql.org; Tue, 24 Oct 2023 17:34:13 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qvLIA-002V0W-Jg for pgsql-admin@postgresql.org; Tue, 24 Oct 2023 17:34:12 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-9b96c3b4be4so695235266b.1 for ; Tue, 24 Oct 2023 10:34:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698168849; x=1698773649; darn=postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:subject:cc:to:from:date :sender:message-id:from:to:cc:subject:date:message-id:reply-to; bh=zIFbneARF+QuHFqSLuLYWXny6NbH6vBf3KfavLo6ZL0=; b=aYsB2+XyiTGPaaGte2Tc62UIBjzOYS1Ml7c4bxi5a1nTn2HnWqyLd8bo0CuXhpIvkw QEf8m1X+qfIKks8o4ubrGb4Kq8CAqBFYuVC00tH52G7fZGv4XuTSgKVUSNg/OC5E0Pzi zqnI0IFDHT5pzRetjVKwKwkm8d4KRCrDcSZrdZzYIZtMlajMkQ47xgprKRhm2LbbJZy1 VXSud2hYeGUd33KUZHhyqSJ6DSP/AombG4dTudIkQSIZ7rFFLFb5SisVSPc7v/Q1cCbM c5K2hjRil0xnOiau12HaBlWYu+LPC21PbR5FygtDuzqn73Ti6NvajFZa5vsjeUQuqHAu 0yQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698168849; x=1698773649; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:subject:cc:to:from:date :sender:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=zIFbneARF+QuHFqSLuLYWXny6NbH6vBf3KfavLo6ZL0=; b=AILjU2payTGtBHgOP7oTxlZcAk4tccigMBzBtWNK/NyOoA4lXLyGFqEwer4C1OProc JUTCtv+VCVq5vfRxNkZg9pYlA54kbg7VifLrkK6Fr1unOiOw6SArkKr1uwoRazcKHIVN uV2m0odWkjuAdmB8MjZPcnvBFoFpWeN7XcNNWY7lgZ/JX/3BZFQxGgnfhMEo+tnRj6zy /lFMol5aJlqGqWCHO4Il7T5cPDBeEgafjUavsj4nPqPJXkGlZhQnHoCMRvUn3DdWBk+O tFYlvmqtEQa9Paz1Aa632s+5rdmFXgtImjt/7UrJnXMzx4C4sPsBXfsxtyoN2GOTaDgh MU8w== X-Gm-Message-State: AOJu0Yz/7qHoEQw3Gb5sSIzBmh+e3HaeRxYcg76OpwmMlZdz7J26S1zd 9bBlvb8cWxj48ZT0MCcYWXE= X-Google-Smtp-Source: AGHT+IHXr/IrpQI4cRKeG/u/VO/Xdd3DgRhPF/oA3wD7VNGxZzlLALc8b6mo831neGv62KBZMt9csw== X-Received: by 2002:a17:907:2ce2:b0:9bd:d7bd:1a52 with SMTP id hz2-20020a1709072ce200b009bdd7bd1a52mr9263308ejc.20.1698168849095; Tue, 24 Oct 2023 10:34:09 -0700 (PDT) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:34cf:1001:f11c:3b32:31b7:711]) by smtp.gmail.com with ESMTPSA id f26-20020a170906085a00b009ad8796a6aesm8559901ejd.56.2023.10.24.10.34.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 24 Oct 2023 10:34:08 -0700 (PDT) Message-ID: <65380010.170a0220.d0c4f.7469@mx.google.com> X-Google-Original-Message-ID: <20231024173407.GU27104@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1qvLI8-0004IX-26; Tue, 24 Oct 2023 19:34:08 +0200 Date: Tue, 24 Oct 2023 19:34:08 +0200 From: Michael Banck To: "Wetmore, Matthew (CTR)" Cc: M Sarwar , Scott Ribe , "pgsql-admin@postgresql.org" Subject: Re: pg_restore is not working References: <0100018b62722391-65a890bf-5d6b-415f-8831-bf8ae2a09fde-000000@email.amazonses.com> <7102931C-1588-470F-95D7-39E50320690F@elevated-dev.com> <0ca8de602dab49a9af7ccce76bb842ef@express-scripts.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <0ca8de602dab49a9af7ccce76bb842ef@express-scripts.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Tue, Oct 24, 2023 at 05:25:02PM +0000, Wetmore, Matthew (CTR) wrote: > In AWS you need to use –dbname, not –d. -d is the short option for the --dbname long option: |$ LANG=C pg_restore --help | grep dbname | -d, --dbname=NAME connect to database name Michael