Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fTldp-000833-IA
	for pgsql-admin@arkaria.postgresql.org; Fri, 15 Jun 2018 10:07:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fTldl-0003TQ-Ob
	for pgsql-admin@arkaria.postgresql.org; Fri, 15 Jun 2018 10:07:33 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <czezz@o2.pl>)
	id 1fTldl-0003TH-HK
	for pgsql-admin@lists.postgresql.org; Fri, 15 Jun 2018 10:07:33 +0000
Received: from mx-out.tlen.pl ([193.222.135.158])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <czezz@o2.pl>)
	id 1fTldg-0002N6-KI
	for pgsql-admin@lists.postgresql.org; Fri, 15 Jun 2018 10:07:32 +0000
Received: (wp-smtpd smtp.tlen.pl 31194 invoked from network);
 15 Jun 2018 12:06:54 +0200
Received: from localhost.localdomain (HELO localhost) ([127.0.0.1])
          (envelope-sender <czezz@o2.pl>)
          by smtp.tlen.pl (WP-SMTPD) with SMTP
          for <pgsql-admin@lists.postgresql.org>; 15 Jun 2018 12:06:54 +0200
Content-Type: multipart/alternative; boundary="2LXKJXAICGHUWNPJXQLTHnhgwp"
MIME-Version: 1.0
User-Agent: GWP-Draft
X-Originator: 80.219.254.41
X-FactoryStamp: H---
Date: Fri, 15 Jun 2018 12:06:52 +0200
X-Draft-Variant: new
X-Draft-Contenttype: text/html
Priority: normal
Subject: =?UTF-8?Q?schema_update=3F?=
From: czezz <czezz@o2.pl>
To: =?UTF-8?Q?pgsql-admin=40lists=2Epostgresql=2Eorg?=
 <pgsql-admin@lists.postgresql.org>
Message-ID: <fcd6f839727c45638857b40cb0aee9a3@grupawp.pl>
X-WP-MailID: 5dc32791586157dea328b105765a693d
X-WP-AV: skaner antywirusowy Poczty o2
X-WP-SPAM: NO 0000010 [MXME]                               
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

--2LXKJXAICGHUWNPJXQLTHnhgwp
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8

Hi everyone,   By executing following I copy schema from Machine1:  pg_dump=
 -s &lt;database name&gt; &gt; pg_dump_text_filename   and then at the psql=
 prompt I can restore it on the Machine2:  \i &lt;pg_dump_text_file_path&gt=
;    That works good.  However, is there a way to apply only differences of=
 schema on Machine2 ?  In other words to update schema with changes from Ma=
chine1?   Best regards,  czezz=0D

--2LXKJXAICGHUWNPJXQLTHnhgwp
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<div>Hi everyone,<br></div><div><br></div><div>By executing following I cop=
y schema from Machine1:<br></div><div>pg_dump -s &lt;database name&gt; &gt;=
 pg_dump_text_filename<br></div><div><br></div><div>and then at the psql pr=
ompt I can restore it on the Machine2:<br></div><div>\i &lt;pg_dump_text_fi=
le_path&gt;<br></div><div><br></div><div><br></div><div>That works good.<br=
></div><div>However, is there a way to apply only differences of schema on =
Machine2 ?<br></div><div>In other words to update schema with changes from =
Machine1?<br></div><div><br></div><div>Best regards,<br></div><div>czezz<br=
></div>
--2LXKJXAICGHUWNPJXQLTHnhgwp--