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 1mIE9i-0006fu-GT for pgsql-performance@arkaria.postgresql.org; Mon, 23 Aug 2021 17:54:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mIE9g-0003lx-LO for pgsql-performance@arkaria.postgresql.org; Mon, 23 Aug 2021 17:54:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mIE9g-0003kh-4Q for pgsql-performance@lists.postgresql.org; Mon, 23 Aug 2021 17:54:40 +0000 Received: from sonic317-32.consmr.mail.ne1.yahoo.com ([66.163.184.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mIE9a-0007wn-TK for pgsql-performance@lists.postgresql.org; Mon, 23 Aug 2021 17:54:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1629741273; bh=+9TNrLC//xjUyH5UunNTnqi0SE+eUtyQ3XZ8J+B4dXU=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=nl4ZWJBu/A3YW6wF1eCzc2oCbHqPgBuFzZFCEmLIc5Qc+A6m466llVdxOPUmn5lvhskQDSyLO40MzJHVgKP5vyoaMFj0mauM5yhJHIXP/hZjQutd9InGDH7WDV3aZrhaGlz/u7VRSkh4MECseuU8tDEYLudFIYGrqMQp3UVptrQR9qmpMwMI6dJ+iOu5H9Qn/qGd3+/8wkbU2vbXV7g53C9IMPeyw9TZjOt17jmSUg7b2ecpt9sZyakI3tVpjWEQ7uYLlKT02tgXvCNb/zBfjJcZ8WPOdsSovTpwBkThP2O9mq8oOjQthoB/60k7XoG0eYil4XCorxpe/4BrqSgAjw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1629741273; bh=vjVQNat5O3SBEI28yIrtnp4M0b3IK/hY8GExy23j3IO=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=XyDKtoDAigbZQUrHVehaPQvcmvddJXwYqVzR4Otjv66TsMVXrdTTYrVaoAzbi73xid0MAZeipTIQHvr5aBVQyuCyEOJoexbbboP4/69j5fw/VT9xPYuTPgb2ieSpGKw3aE8VdHXmdbi/0QxW8P7rYUMxynE8nO9PGfI0t0Gxrp9JMEB6u/esJooJaawQnVJSw83Ry7nznjO78HtUwv9N4MdJEeZ+T2aVknRAQFiqJt1F6FEEb1RRGkrJnn52y75HSTmmJPQdxTHqkxPIqt1rDOaK/SCd4A1kKKhgwp51K9YNmrfIxtFtnZDX1gXoPIR5hLj1FqqepGIDJ1CklPVh5Q== X-YMail-OSG: 1Uc9.agVM1mtis3NvD7fTQWYd7FBTDkLcSM.oxRrCxAQorC.sKFQrIEhLrhBywV MyriM5qcNUTO8on9TlrWnnxCxGSrY6iW9UaCJfiE60nF.wUsILDOxVC1RgbW1ccdleLAIAIhTe7B M0QMTWq.JZsWpkq1fZmY4cAtfL8KKnB7GJu7MbiJNhU1yexsnrK7mL_exRjkZNSvtR1dMsVAqquy mm.U3FRXXWJGYl8U67T9Hy6VBBvi9Ok.34aXN4w6yRpGNsLc9slnYYXU4nZw1qmTphC_IQc_BlI6 BaJFTJsL0mvGWYXtUdKdAcOx6ipa8pLUhHpN7wKSVH5GnBYrOMstwRfxGZJSfDlpJk8VP4_gn7xu yzuu0h5ZKG_JQiXXmqK9H12AzbS5ziW6sWskyC2if8IlHRHkLrpOUDxRcAKgOszRnHMQwFq1z5cZ DqNfjL2jK5b518onq63NJUkqrR5temuoE.OdxIlP8NW1OmsxSLpDHIaq8bVYd.GKUlhPWK8vYIrV KOB2SyOnW3sO05V0ogPoI7X008OETSqqRwpE2LAIeRG.pqdasbapHkQOPs4PBi5cQEHa8uo6kif_ y6XrhlaHvO9wy8lXg84X1gftwRO8lEVdFqWddCfWoSu6Zvg1UAk_A662xs_XrvxKiQwPiYfFMno8 WOOA7qPimMQy6fzH5AGor9KD6gm1o3cG4H3DUUoloGVN2lSJ7qYenwj7Mxrzcef6ITAiIuvqwt2M EuYiJ2xsGlXjC0dnuqGbJvAe8Ek2Fzdj6kmIoyepXRxCyx8Gxmn1GLedwZgy4Po0YMxbxaA9Q3Xp ojWqrLIrYJ9F1QelysqIZdRAZrzLgUOzjF24INque.u37pOw.yIMbbiLydjyVrw98Ijzwa.sbEDP 6B8LfmsVVECro1W1k_sYiNI.WGQoYZiRLvHG_2bWChiarjPyDv6pb6UUrpGvPGS8qhShG7wHWUau AFJSKsfK75aXJ8VDnzzBm00XCwL4jqe46L9EQrciAAciUzgFrWOVcBE7wOSlN11CB7fEa.6oETt6 6fV7mG6SVh.zDfeerOKL7wnyjtYHpKuuMMkcWDWqwY2GzNCO4j0EUfzoGeh2hRr2Scr6tJoklal9 SOeznBVAbABUe23tSgiDmp9Pk.Y5Qilt7U9kYkEJKaMn7ae5NuBQFkXgHsWJHY7WnmhHxn47ZSXv oHOUGo87NfhK2KN967AODCw69stng02GBzimJcG0Fw8R9qjVymd7hM6woKImVYjwLPdS2M_J2qet 7KRRrCvOEZsWFaEemThTLe_Zlsa7ZCBQG9TTSzccL.0nlFzt1nY9PWzq_u1Crgu7ic8muR9gGLm8 1kXrwRYsO8s0bbzfB7PpbTlfEY5kjX.szhG642eu6OhOb.emz2eWei5z6qa4Bf2Ya.hGzbJ_fW5F a2Sv2RYs3nI2v2Gv2TgS8L.QaBtdl.2WnRg2HyiSOqLn0VdXu.5gL5t28e_4D610bZf239Jxov18 aUL6i8ZlfT2a185myvit7C2FU5wToF5oilp0IwSLIZ0Pz9Ylfqht9ma4s1shcXK8EUJ_imTjl9Dg _od5AEYZkLmB4EjDMVCjN.at8qWZHtql8dqFFDsi1LcU4iYKy66RgxQg5CO95t8UEDIyFkZ2XI48 spI4BvM0VywgUAcOWZaHQiWwkMmovX_stq1z8GvVZYH3m.HGJtOYh8NM6NkG.K4F3N0B_Gw0DibS e4i09RFFc4FsyRWeF9CEEpzKytT52Tv39Lm462HTJGbwGa75S4_hP4lHS6T4QcUp441kJF09F5Qf F3A_KFZgIy9f16xgWvwiO_aV5xl.V8KzCY8PPZGYgoXrOXyPb1KSz5DqrFVHcf6ysoebyC37Y4.X aeDB8wgE7N7FXKmyEOtdbpgfiOQgz46Txk_xnC8PxbMKhnoI8wfyI0f0qQfF8SvipVKZmIRSi1H0 lN8MQrFqUfcfNA1nu1FRmrQx4tC8qpaXG3cFY2C16b4yzCIulr91_iYe04YbN5R0YZMkUvhIGYDk gpSylLGFld9vlxNfEjdEX3d3INpZUkeLd.PH0GGm1synAJx24wjCpn4KEd_LHgcGREimFOYg6JKj 7UJ_RCvPf.rCep9v.POnacLsPlaNXRWZyGOMJUlwUGX4KifsRAjA8NxkxBCd4MGgN_PESowJtpHI JaE118w9XLFPrKmR2QCOlirsE174pBIkUXEQabSEukwWlv9m0nx1KUI9cty.d9OLsJlNoh3X32hp 14mqfXGjOcaJ4bQKMQsxlkd6JwHF.LAPwCzC6Ba7LNSYcC7Qp61mdPq8gvQWeyO4TFApHr1tYU6E XhSVGtzRKclx0MQoEbw-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Mon, 23 Aug 2021 17:54:33 +0000 Date: Mon, 23 Aug 2021 17:54:33 +0000 (UTC) From: Nagaraj Raj To: "pgsql-performance@lists.postgresql.org" , Jean-Christophe Boggio Message-ID: <543515895.715906.1629741273076@mail.yahoo.com> In-Reply-To: References: <2083887101.547666.1629711847197.ref@mail.yahoo.com> <2083887101.547666.1629711847197@mail.yahoo.com> <4a3a3b2569bf521a8da585f3f87c8e56c6d19145.camel@cybertec.at> Subject: Re: pg_restore schema dump to schema with different name MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_715905_1787813782.1629741273075" X-Mailer: WebService/1.1.18906 YMailNorrin Content-Length: 3006 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_715905_1787813782.1629741273075 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =20 Wouldn=E2=80=99t be easy if we have option to_schema ?=C2=A0 Absolutely, I should not alter current schema, as it live 24/7. Thanks,Rj On Monday, August 23, 2021, 06:39:03 AM PDT, Jean-Christophe B= oggio wrote: =20 =20 =20 > The only way to do that is to create a new database, import the data > there, rename the schema and dump again. >=20 > Then import that dump into the target database. Or maybe (if you can afford to have source_schema unavailable for some time) : * rename source_schema to tmp_source * import (that will re-create=C2=A0 source_schema) * rename source_schema to destination_schema * rename back tmp_source to source_schema =20 ------=_Part_715905_1787813782.1629741273075 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Wouldn=E2=80= =99t be easy if we have option to_schema ? 

Absolute= ly, I should not alter current schema, as it live 24/7.

T= hanks,
Rj
=20
=20
On Monday, August 23, 2021, 06:39:03 AM PDT, Jean-Chris= tophe Boggio <postgresql@thefreecat.org> wrote:



> The only way to do that is to create a ne= w database, import the data
> there, rename the schema= and dump again.
>
> Then import= that dump into the target database.


Or maybe (if you can afford to have source_schema unavailable for some=
time) :

* rename so= urce_schema to tmp_source
* import (that will re-create&n= bsp; source_schema)
* rename source_schema to destination= _schema
* rename back tmp_source to source_schema



------=_Part_715905_1787813782.1629741273075--