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 1sY32J-008RO3-04 for pgsql-admin@arkaria.postgresql.org; Sun, 28 Jul 2024 12:30:03 +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 1sY32F-00AmfF-K3 for pgsql-admin@arkaria.postgresql.org; Sun, 28 Jul 2024 12:29:59 +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 1sY32F-00Amf6-4H for pgsql-admin@lists.postgresql.org; Sun, 28 Jul 2024 12:29:59 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sY328-001tqV-Hj for pgsql-admin@lists.postgresql.org; Sun, 28 Jul 2024 12:29:58 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-52f04c1e58eso3302771e87.3 for ; Sun, 28 Jul 2024 05:29:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1722169791; x=1722774591; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=MMtz+5YsePBhVf2I0F425UtfmcZtOZJxkgAyIB1IUq8=; b=YEb6t6NDCJYnGX5EPElVu9bVMC5Zp9SuMaaygAXyNoop36Ge9VpyJgBgEQnYZjR59U ws0ewTxVsldtQw+Vo9TX4n+67KEI4dsaMNuNlSGl+su36JDV7A+gAI3rEMyJAKbZy3Kt s8XFtdG1akwDoKAB+K3xzJ+QVhL+Dg05XhhVi3grb6E0On0ma/Mu2xkVb9TcXKr4EzCM b6cEsCnuoDRU9+CBGNiiSEnHlu2gql48ljKOug9f+v+0BIMvJ3JONXiZcXe9nXVcpDKc n6yw/FJQneOquftXD2nQd0KCTL65VcZzUWroRTRuGDcB2VOTLNq2NZpKUp/ZDHc0tLAQ ARiw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722169791; x=1722774591; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=MMtz+5YsePBhVf2I0F425UtfmcZtOZJxkgAyIB1IUq8=; b=gMpOF/jjqkGHS6XsO++UfqJndJIv6JTKTkSqqBpGe7JI8YCVppJF3losG0uLI9i6/H trlbqb5Hdv5IzqjsZkO+64VoG2/BBeowhpRzQXMZM6Zu7dkaC+Kxw/O/siRYDbkZydx5 KXgzX/WH0itK4VTDlL09yBcVnh10ii3DxQnAvPlXvo1+wM1KF8WltFibgKzvCktKF1JE pIHtXMjQnB+8btBLki0/AwEktwi0V08oQnS5kcHBJxlHmhcRApF2Rse8HAMoyJNwIgmF 11tdxbcxapiYy5ZVJmsVqfr/9F0kmrvxNczWfCzsxu2KhGsDNmFPUXvmZucb3KdcOmza pQpg== X-Forwarded-Encrypted: i=1; AJvYcCWPO++h1UmLBGWkA22Ql6Nf2AK1IaA8VkkxH6npBUJocFkcxyukxCZJMEc7ShfN7xt5FCBzULAhB4sQw+oGFI+yEZ8LHGWZx8/BZDyuqPG+/w== X-Gm-Message-State: AOJu0YxSpdzrgXKgN/fS4cb4JLsT2fsD3GjueMq3sCsdY3uFQ7GYN8UQ oh+t+7xKaIGVQaaQl3SwWygFKHc2/ip6XEYfCarTt4Hq8w9LBd+OUL/aZb3ehwA= X-Google-Smtp-Source: AGHT+IF1tfiCBuYv530/X040FxdJKDs+x5IKXnOLE8PXPhDjOLfkFsZK1vq/aDCuy71D0L+isfVFPw== X-Received: by 2002:a05:6512:1296:b0:52e:933f:f1fa with SMTP id 2adb3069b0e04-5309b2e0b62mr4056070e87.61.1722169790099; Sun, 28 Jul 2024 05:29:50 -0700 (PDT) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:260:122:471a:3e46:e6b0:faf6]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a7acab22f9fsm383697866b.6.2024.07.28.05.29.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 28 Jul 2024 05:29:49 -0700 (PDT) Message-ID: Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server From: Laurenz Albe To: Wasim Devale , Pgsql-admin , pgsql-admin Date: Sun, 28 Jul 2024 14:29:48 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3 (3.52.3-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2024-07-28 at 13:09 +0530, Wasim Devale wrote: > Can I use below command directly stream pg_dumpall from CentOS7 to RedHat= 9: >=20 > pg_dumpall -U postgres | ssh postgres@redhat_ip_address "psql -U postgres= " No idea, but the correct way is pg_dumpall -U postgres | psql -h redhat_ip_address -U postgres Yours, Laurenz Albe