Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mI6X9-0000en-Tp for pgsql-performance@arkaria.postgresql.org; Mon, 23 Aug 2021 09:46:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mI6X7-0002Hu-71 for pgsql-performance@arkaria.postgresql.org; Mon, 23 Aug 2021 09:46:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mI6X5-0002Hl-Fo for pgsql-performance@lists.postgresql.org; Mon, 23 Aug 2021 09:46:20 +0000 Received: from sonic310-50.consmr.mail.ne1.yahoo.com ([66.163.186.231]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mI6Wy-0000nl-3U for pgsql-performance@postgresql.org; Mon, 23 Aug 2021 09:46:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1629711968; bh=kjoTR2VorE8cTiyc6XFYPwuvqOk1M8o8VUZWLSvZ3uk=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=DuYgZhlKoS9xrGQckp2nppqm22P24wT3oPJqacORUIDV2A6hMLGGG7HLTE1DsmQYhL7sPgLpXaUcShTaCqivQQIcchbW+WP3BxJeh8/BUtMPSwlZvE5mQDPNryLMj52XFuKzK8ZCj5O9I9M5mYLSuKxCaqdpBhIHHDQ9XQbC+3q9eU4OGWtLtj7JxSKlJnAXQyTiNt4qup793bWv4IpKeU0u9rkx0OMbh8DIVRE+1N81YNbz5LYiVkqW9HuwylxcEIOXFPXijvN7GQkuaNIc3HGJeRRx2ERTAb+2UkqQuT3y/ycoeVoVIxdwNt296WRiBAO9OIary9U/hAxPSXSDwA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1629711968; bh=R2PgdSite8bOIm+wWwNx01oNP44Qc/DSfWcZY9m33+T=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=HeQfud1R4b+rd3Q4b52mxHpd/Xh7GVX0CweLpMh6fbf6Nlq7lIP00J9ROrkErSKHVRkhBSeJ3uQlfZQ9ccphS/Q2qXm7mBo1h5Uwfgyp9prfYIp8ajboal/BFqXxzvQnYcsxIZ/l7BUsQYyq4MWvWNhfRCmN8PRW4uJWLBOgKsEd8zYwESQght2VhHZh2fjQ239JdOS4IrBk/3DtAsybOncX0u1QVf6ARusC+5AnukhNWmF4/ycV1B+TgoTY6zehdbZgc627ZhYzjC/COTyJlsjubCM0rinHFVe8zT4gpbjQWH3s/am5kmGVhsNyyK9TXvYwQqIGbg4qhdCtDSFAMA== X-YMail-OSG: L25EbHYVM1n29JlaDOt6bk5ppqCRMatr9yAewqRfqwO6f7WQk6ZJZlmbzwQ6Xn8 QvfkxVMBrtvHnh9LEovo7Ia1Qk6R1HrHPOInuXxn1I97SZHB4WpgNSLZW4v.c.MfVqBa_7OJY52I OHfhRlaiYWkyVCitRaZYd2WyDn_T5Ovx._YUT5v5bzFp.fQx4D.VLXImVZxUtju_60tf0v3ATUbt 3LU0N1H5IT5e3pWfvxUudlo5c211YrIs1Cwj7lBMnEzHLwuvPXdcwbcEPh9KJqJWAHorPmB.t0Z9 L9.lPgH184Td0Pkuc275NWxwjsSnI5N8EP.eXG_zLhBck9VEO3PrSsWsCf1CKNvTTV1F_Yvhiv5a E_6nGOO5DhQ1TIND6nkA3Od_oYX3G8oS4iL2Cvgeh4MRqUf92.KHnD9zi5ZM1GGXqITIH9LQyHC4 17PSuBPWMS42V9rpsTKivJ0N_OPJJWxTprz4fENbwh6a5wLVupLiQu1pJDXFm8eGAl4TyWYi8gNr hOJfxXB611BLdZE1C_6XtYy4n_tFvGlvxAsKtkZIwO40lUuAkzGknvTJXqiXXTMGY.69_Q4roICT Tm8B.mjtH2ZqnDa4lSmiCVoZ3RVPWtBbYzqAq6A54AO_nGozbWoS4PHcd9gbS1Z8bkBM.oHyCXE_ mJVVBpouW4bKo0ouy4TLuuQHm40GlnPn5cY6an.nUs4loKDKA02O938xQ.78OzqagKQwCtc0Jzz_ phzZpRqM_HjaDI01PSdaj7g6xWCZCS3O9LTzo5Bym9yVBjuDkSFSsee8_QvruONZKBw4t4pfdcE8 51Vz9jmNQN8BUyYCQC5RbWLYS566rioDr_tWYhJV9DIQ5fxGLejVTqkNLY7LHgTE8vKEQ0o6Pyc8 4CI.MUw__kJoAUYCxomWiC1Pi.pdp1540JUq_wTjLbHOl012xdr8ieeOvKSeLMfrlqUaRFLV_anN tbB2tdSYJ7sAjqF0nwi4eu.J863CRQbe14zLwICKXr3ZAyKQ3_otApgZEqLnd.lqB5Gunkc06xAP xFj6QvMER_YifhW.Fhu6VX_HNGFKCCjThm88ZIwt4EEXijwgVRJEwGRbkSJgi3fVa0PhYpwo_6yl IXNtiVZ_c4k0mOcdteUmV3VRiwi_2x7y64fhg7DWSRQqW9JqJ87R9XLTm0K8cpVEnRE1xLL.A77i 9aN.K4zMV7Nz.0TOeszZe7M1ZY3WriIoComjP0RVF7wwqn8ucfwZTY5zpCC_A4uU82QDESTxCNzQ THN96gBC9YibiRPudDI3bgiZYKHvapl921TXyvvlObT_TDItNKL7vte2DxrjZLiU8hDp8IpyY7qe MkcWlVPxJ5cRR04zteQiM7VOpQHWx.hbWWt87Sa31nsIZFquxLwmiNMIfSfOSa0ULHuJqyVV_JhD sYXaq39bBD0rDTsjMymoQ4UYhD0l0nORkH.DNw0yAvJttJxxzFZ1jVHB5n7FEekOUIbv8ZnmT3QZ pWGAbiEspslrJegI3E0M298SHmFjllm3MVmG41iM5a0jdmFYV8ddtqR00v.Ja39E4doT9RFp_ynp fyJ7ayHwRSqOJ6WgB0wbKPg5LBFVdXly_hQRWd_uXbU8GgrvaSzOdXYLWGmvAGb8AvZECutO7q1L I.QZhG1PEjjZ7LGPzwzWeYtrZwVDDYrmy18GAoXErjf067_BuR2q4AOab1T8JfAou96FXTh3kVjC W9rEvQjrL9wKDeTcpzyAd21jq9naPYL8W55Z.wOCewqYaunglcG56azBapJ5hnZmwq.jrMRfOsN0 KXZhgoCVmzi2q0CHNk6_bMPEdLE0adj2QNK4hL.akXTeHGJsqNzamYMOwix8y16osNkg0lE4YVxR 8_it6jUGM1zkBST6sgHRY3rMoaiPBrYfXGExRJkKGl3wd3bTSLcidkIZWP28qD4AuprTSs.4LmjY pMbU6NThoOr7Y5bwx65oDQhw8bbnvU4ao496ii0sey_1b3VnuZm9MWEQ2QHKEzhwtQRkdk6pNOKE SFmd1uiHJZ886zfk7B3saczqJ.1s_77O2HD0OiMcFsqaZg2A9JnfI0iYyWD3N.vjLVMdmI.qkKDi 9zMfMzx8UgCwImcvakbiyi6FOVrbPHyw6DWIKEMbKHc9y_Gnzx8CQkOG_uyh2Q5Zhq44UcZG4Ihi o3Ov58nP9jHbX4f9QnvE0LE.ulO4VS9FfE2s9cX4BWINQQYNUvoAFbz4r_CkfMFyDzAtpe8Mryfb .hNWEY_eHKW7TDCsBmqAhgIUIp2_knGlubGpPWJdKHKsUHCwnBiPRlnQN2qmTj.PJ_VG813IPigG dPYUmr_78AFEzNw-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.ne1.yahoo.com with HTTP; Mon, 23 Aug 2021 09:46:08 +0000 Date: Mon, 23 Aug 2021 09:44:07 +0000 (UTC) From: Nagaraj Raj To: Pgsql-performance Message-ID: <2083887101.547666.1629711847197@mail.yahoo.com> Subject: pg_restore schema dump to schema with different name MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_547665_511919870.1629711847196" References: <2083887101.547666.1629711847197.ref@mail.yahoo.com> X-Mailer: WebService/1.1.18906 YMailNorrin Content-Length: 3344 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_547665_511919870.1629711847196 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, I know I can alter schema name after restoring but the problem is the name = already exist and I don't want to touch that existing schema.The dump type = is "custom". So effectively I want something like.pg_dump -U postgres --schema "source_s= chema" --format "c" --create --file "source_schema.bak" my_dbpg_restore -U = postgres --exit-on-error --dbname "my_db"=C2=A0 --destination-schema "desti= nation_schema"=C2=A0=C2=A0 Currently this is not something can do. this functionality is there in orac= le.=C2=A0 Is this future considering to add?=C2=A0 (it would really help for create a= ny test schemas without disturbing current schema. ) Thanks,Rj ------=_Part_547665_511919870.1629711847196 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

I know I can alter schema name after restoring but the problem is = the name already exist and I don't want to touch that existing schema.
The dump type is "custom".


So effectively I want something like.
pg_dump -U pos= tgres --schema "source_schema" --format "c" --create --file "source_schema.= bak" my_db
pg_restore -U postgres --exit-on-error --dbname "my_db= "  --destination-schema "destination_schema"  
Currently this is not something can do. this functionality is t= here in oracle. 



Is this future considering to add?  (it would really help for create= any test schemas without disturbing current schema. )


Thanks,=
Rj
------=_Part_547665_511919870.1629711847196--