MESSAGE
DATE | 2022-05-06 |
FROM | Yusif Suleiman
|
SUBJECT | Re: [Hangout - NYLXS] [Health] Restore data to new installation
|
From hangout-bounces-at-nylxs.com Sat May 7 22:10:53 2022 Return-Path: X-Original-To: archive-at-mrbrklyn.com Delivered-To: archive-at-mrbrklyn.com Received: from www2.mrbrklyn.com (www2.mrbrklyn.com [96.57.23.82]) by mrbrklyn.com (Postfix) with ESMTP id 0F445164024; Sat, 7 May 2022 22:10:51 -0400 (EDT) X-Original-To: hangout-at-www2.mrbrklyn.com Delivered-To: hangout-at-www2.mrbrklyn.com Received: by mrbrklyn.com (Postfix, from userid 1000) id 823BB164034; Sat, 7 May 2022 22:10:01 -0400 (EDT) Resent-From: Ruben Safir Resent-Date: Sat, 7 May 2022 22:10:01 -0400 Resent-Message-ID: <20220508021001.GM25065-at-www2.mrbrklyn.com> Resent-To: hangout-at-mrbrklyn.com X-Original-To: ruben-at-mrbrklyn.com Delivered-To: ruben-at-mrbrklyn.com Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mrbrklyn.com (Postfix) with ESMTPS id 8DF47164011 for ; Fri, 6 May 2022 10:49:52 -0400 (EDT) Received: from localhost ([::1]:47886 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nmzHD-0001PP-Rz for ruben-at-mrbrklyn.com; Fri, 06 May 2022 10:49:51 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:35758) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nmyQs-0005yB-3o for health-at-gnu.org; Fri, 06 May 2022 09:55:46 -0400 Received: from mail-he1eur01olkn0802.outbound.protection.outlook.com ([2a01:111:f400:fe1e::802]:10734 helo=EUR01-HE1-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nmyQp-00074G-Sg for health-at-gnu.org; Fri, 06 May 2022 09:55:45 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=VZXQH8bhmEwNSGSDSAjNowTdAz9gEObpDCrGzG4msWaQ1+/Uq1tTkWn0Lqoz8Ss+CyEsM77if66iUrvJS5sdA6+NzTHvYt7SyVrBGShJ2URQiedyzzfsc77Xh9sCl8ut/kTregQ1HcADGPO5CboYEDZ0IwYOK5xyA8nQd9oNfCzQsVVtVLllETDxplM1Uco69oIIGgXg4GOqVHeKf2VIj1qaJNYGS0ILjtl4S4pC/G9+BSTlExy94U9C2di9C5xlFZSMXizBEp1ZWU4QLQz/BgqNIYoeaDv7ZZ+HLeOP3pQ6Ms5EAgu0Dzm1GxoD26hkqDv1LymNvD5UII5vBZyTvw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=BXTf7N6w20K/HWVq1AFoN+nHa54xIrJ4hJw4J8RxRWk=; b=cj2FDbbPVvI0bYkoooUZmxfh9vzs7L1jowBeBlObFiQKLYYMWEFnSvso6kzIGKrYWbtPkC8Bc2ZiONZEhtkfLtXhflxHgco/VBpxY6OXc+PcL7CCKWGNsXODj8dWg1vrIi/cxi+2jzCohydXTdRn7OoZSTMo+3WpL+Y9Xbd7JZ2bOHfopxeamYE5jEwwIOBbcvIoxrUW5uCyv52BqDxn8eBj/YQbh8aHX1ala8J4kFs0kjgVP5YgBqGfHxZ4hSk7w5HOQaaaE5U0rG7ot4eiH92PLsL8itx4GpJTLGzZt4oAhe2PcLwg35y+QU3vQPgkS3nB4sTbsmo0Olq+72agBA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=BXTf7N6w20K/HWVq1AFoN+nHa54xIrJ4hJw4J8RxRWk=; b=uqpT6QCjoinOXpAHUhpTqngHmTdA+WRHR5cSyDPh3c/Nvabp89/u5ULShUTLR/ovfoyk0ClrNxPe703yxTcommAZQVAxJ4fVuBq2yTQx4HPwAhLqnayZ3XbaJytACrGgQYecr+DDXbyb/FqDmgTiUDidEUClBcwW/uTkIxqPiTWLWz1cuJMem8ywsVVbfgMZqnHDoewpKXvHaGhTNpZXW0VcSwRxiCPNNJATrUcGfkfpqV4o1hnWcUvlKkt2XZonbm8fKypOCOAjM5a60O0jf+r83WClX1hn4Cz3K7ixIFTf+OCDyuQXrGFi3eJJ4RWWxC2zXic+crPocs1Q9k1t8g== Received: from AM5P189MB0579.EURP189.PROD.OUTLOOK.COM (2603:10a6:206:20::32) by PR3P189MB0939.EURP189.PROD.OUTLOOK.COM (2603:10a6:102:4e::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5206.24; Fri, 6 May 2022 13:50:39 +0000 Received: from AM5P189MB0579.EURP189.PROD.OUTLOOK.COM ([fe80::5d62:9fe2:8c2d:ad17]) by AM5P189MB0579.EURP189.PROD.OUTLOOK.COM ([fe80::5d62:9fe2:8c2d:ad17%7]) with mapi id 15.20.5206.025; Fri, 6 May 2022 13:50:39 +0000 From: Yusif Suleiman To: Luis Falcon CC: General GNU Health discussion and help Thread-Topic: [Health] Restore data to new installation Thread-Index: AQHYX/SN9Ycbdv7P60C8zwRxHEVKp60P+KmAgAGR8os= Date: Fri, 6 May 2022 13:50:39 +0000 Message-ID: References: <20220505094409.284a7b33-at-beastie.gh> In-Reply-To: <20220505094409.284a7b33-at-beastie.gh> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: suggested_attachment_session_id: d44c98f8-05e5-50d0-5005-c1be474c7cd6 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [EmxABTq2tjo5Jb+FC0tJM5NYqadivPGv] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: a73af02e-399f-4298-c5c3-08da2f6767d4 x-ms-traffictypediagnostic: PR3P189MB0939:EE_ x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: iQxAZFuSCGBOfh8XZgAFjs4absNiAoEkA8i3h9uiKopsLdj4CBdP/G+DtnJ/CeAzhalHPeEdrnJfmBevOZ1AJvwh7QC1YsVxJIinmBMzPaf12L8g4dIVtMsdaecfkvP4QkBLOgUx8cSAkiBYsm4n5vxGio63yv1yq1tYbmRTMP1lyolvpxyqEvDMeU2riXBatOkZdnRCKpqkXvPHKNVCuxT4rPis3/W9cDJeMtODbzB9TYUNgvXjpghbbmdekZgYqmytARjXc4yr8SnxohqWC+ncXtfcg/+0FuWS6aYfL4SXdaxkP7gheV6yjotGegyXGbLsDKbT3q4+3O26/MMzapGKzEbR2GUsX218KM//SYHVjjjcmCagoNIjWPP29YFuvn9ejTlBsGjPReHVBHpw1mZ5QQwJOdY9SqWic7C5ozydKJ980JTBOET/Kj2lYy2YMaMAdjDFLK+IITdNLJ6BSrnw3M0nHwvXvpOLh6x142aDAkGS4EefYYnledVCIVsdMbN4M4zEGhm/EqkzoFziohY+LQWo/jXVAkqSzdicqoH+QPGGSYg4sluXLipSIm9gdUu5DfJyBp4XGVDEwAng/N3so2E6afyXWAtObY3QPdxODhmTU8c6SJPrRTLo7kbaMVh7JYIPNhDQvV9QmDsTvhh73CSLQB/DYcDmvLFXRkc= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?AKb5n6L1WtdkbRMeFoNpyok2m1nEoKvuXAEAxknMVX0XuKBI1yb/TWHv+/?= =?iso-8859-1?Q?35xcroc/6QAilsQro9Js2UsWlTGh78FO2KfYAKkiBFYzf/lD9Bth5YOXFW?= =?iso-8859-1?Q?hlxrgObR2v+A2ck1GOBeONjgqjBTKkziRU+OYUt4jQh09KI4vtJ0U1v6nj?= =?iso-8859-1?Q?+mXBC62qxf9+Hsp5Xtav8v4sq4/UZkoUJaVOOFfuWBnig1yvWA8I3mbZRe?= =?iso-8859-1?Q?H18IhX9UDA6xTq68u5khYKuQf6wsc8EWRvFzK2NdKoI4MDtNuitifBGYHa?= =?iso-8859-1?Q?rwXxihXO9vc2hGul/nxrUbG8VJ4jTszJzE2wBcJcthqBIRCjZqV1QChtFQ?= =?iso-8859-1?Q?Ez2JlnO9bZUER/3gRW7gBGHXkTOsP55TywaA+V36pH0YHLB1nwmjfjIpDU?= =?iso-8859-1?Q?vj2XZQKnyoTyKmD/3DJwPikhgStyJuB0M1rZCLfOorDO3G9ODwB0MWxZe/?= =?iso-8859-1?Q?seVKEqyx/bqbkpfEOQRLeD89u57LVnZIGQYT+fIZ3F1qmVF3DoQMDpzhIn?= =?iso-8859-1?Q?HwB30oPs/77z/0P5d8wYDZdnytl9tgYchy/se06pakydMpPwrkPru7F0MR?= =?iso-8859-1?Q?m+/N88S1H719fdvuITvHbAVjWQmCPUW6zbpttdQR1mIZOWgiPXzEHGvAXR?= =?iso-8859-1?Q?50bBk1lIG/txRL6XeDFM3u/Wgd0HqV1ChpltUfAcNKJbfGkTm2lgDqGVZQ?= =?iso-8859-1?Q?oZPisIiiLJlyNpeb9558HxGqZr7DT2HBWz8I0dn9fIEIqe+Ijoo8ndMB5j?= =?iso-8859-1?Q?jAi27ZI0g/BaRhnmlCgv7xu7Ws77TlbOH5O/EVqo8Rmf5sU1/1KxtA8w9W?= =?iso-8859-1?Q?WRH2GTdD1aO0c9JPEibleQgOgu60JJGnBmosbOpsE/UA0805WgD0qpSO+g?= =?iso-8859-1?Q?gDTMUR/7QiNr0HgHD9Hhd2iXyZ7kPaT9c5GWyxAIjRY6fifWM84RyHvwqc?= =?iso-8859-1?Q?TF+jJQz1d7CFxs7A1wvmQgSHrXa687KP2kfgWRuwjO/90pyw+PKTP2h2JD?= =?iso-8859-1?Q?uLY7G0GcbNJqR0CNGLUI3JZtZ1p2N6d1FQTWc7sFaoBUumdD/hEU+A+Ztw?= =?iso-8859-1?Q?snTCRt86hBg2a/Yg3dO7ixF5drhQh0Pn6qxZY4X+9J8V3W/4ADaB8tpLIG?= =?iso-8859-1?Q?e5EzEX8VXRW002FZL99VzVZFjTGDV7S5a8+aJuTilE2PW5mNxPZnBUiABi?= =?iso-8859-1?Q?FILPdKQgIS83AoLBK9jOTuJLagKknfDX9HjJhaQSKREmhaKS2S9Xo9DlcU?= =?iso-8859-1?Q?2iI84iOqMZ2cVpmdvEsU0xAscJY1lN5BqQxj0l+WhhGwLsU11YL6SlsVDD?= =?iso-8859-1?Q?fwxTagDhHuwlHLELX0D+lvpFlJV8MeE/LBVBmWsOU++1loRjUCZKNmE2tp?= =?iso-8859-1?Q?VVf6V3k9lTlDwkYTuSxDnAWzWe0zksefVQb1ahChmNUcCpd0d/z8F1rbJN?= =?iso-8859-1?Q?QpEbYacjKbYYn06TsThbfgSYY2NDX9QN9c9qMX5HNdAqH0xCTlrF8hbLLF?= =?iso-8859-1?Q?Q=3D?= MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-4734-24-msonline-outlook-c54b5.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM5P189MB0579.EURP189.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: a73af02e-399f-4298-c5c3-08da2f6767d4 X-MS-Exchange-CrossTenant-originalarrivaltime: 06 May 2022 13:50:39.6012 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3P189MB0939 Received-SPF: pass client-ip=2a01:111:f400:fe1e::802; envelope-from=yusifsuleiman-at-hotmail.com; helo=EUR01-HE1-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Fri, 06 May 2022 10:49:37 -0400 X-BeenThere: health-at-gnu.org X-Mailman-Version: 2.1.29 Precedence: list Subject: Re: [Hangout - NYLXS] [Health] Restore data to new installation X-BeenThere: hangout-at-nylxs.com List-Id: NYLXS Tech Talk and Politics List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: General GNU Health discussion and help Content-Type: multipart/mixed; boundary="===============1314279453==" Errors-To: hangout-bounces-at-nylxs.com Sender: "Hangout"
--===============1314279453== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_"
--_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Luis,
________________________________ From: Luis Falcon Sent: Thursday, May 5, 2022 9:44 AM To: Yusif Suleiman Cc: General GNU Health discussion and help Subject: Re: [Health] Restore data to new installation
Good morning, Yusif!
On Wed, 4 May 2022 20:26:34 +0000 Yusif Suleiman wrote:
Although you could use any DB name, when doing a restore, the best is to use the same database name as in the original, because the attachments have the prefix of the DB.
Okay, I understand.
To create the db user associated to gnuhealth user, follow the same steps as in the installation guide See: https://en.wikibooks.org/wiki/GNU_Health/Installation#Creating_the_Database= _User
I create the db user gnuhealth following the steps as in wiki. # su - postgres -c "createuser --createdb --no-createrole --no-superuser gn= uhealth"
However, when I try to restore the data I still got the error message. # psql GNUTest backup_Fitrah_DB_2022-04-18_143054 psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5= 432" failed: FATAL: role "backup_Fitrah_DB_2022-04-18_143054" does not exi= st.
I believe, something is wrong with me. Maybe I still do not understand this= part. Yusuf.
Happy & healthy hacking! Luis
--_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
1">
color: rgb(0, 0, 0);" class=3D"elementToProof"> Dear Luis,
or:rgb(0,0,0)">
=3D"font-size:11pt">From: Luis Falcon <falcon-at-gnuhealth.org>r> Sent: Thursday, May 5, 2022 9:44 AM
To: Yusif Suleiman <yusifsuleiman-at-hotmail.com>
=3D"Calibri, sans-serif" color=3D"#000000" style=3D"font-size:11pt">Cc:<= /b> General GNU Health discussion and help <health-at-gnu.org>
=3D"font-size:11pt">Subject: Re: [Health] Restore data to new instal= lation
>
Good morning, Yusif!
On Wed, 4 May 2022 20:26:34 +0000
Yusif Suleiman <yusifsuleiman-at-hotmail.com> wrote:
Although you could use any DB name, when doing a restore, the best is
to use the same database name as in the original, because the
attachments have the prefix of the DB.
Okay, I understand.
To create the db user associated to gnuhealth user, follow the same steps as in the installation guide See: he_Database_User" data-auth=3D"NotApplicable">https://en.wikibooks.org/wiki= /GNU_Health/Installation#Creating_the_Database_UserI create the db user gnuhealth following the steps as in wiki.
# su - postgres -c "createuser= --createdb --no-createrole --no-superuser gnuhealth"
However, when I try to restore the data I still got the error message.=
# psql GNUTest backup_Fitrah_DB_202= 2-04-18_143054 psql: error: connection to server on socket "/var/run/postgresql/= .s.PGSQL.5432" failed: FATAL: role "backup_Fitrah_DB_2022-0= 4-18_143054" does not exist.
I believe, something is wrong with me. Maybe I still do not understand= this part. Yusuf.
Happy & healthy hacking! Luis
--_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_--
--===============1314279453== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline
_______________________________________________ Hangout mailing list Hangout-at-nylxs.com http://lists.mrbrklyn.com/mailman/listinfo/hangout
--===============1314279453==--
--===============1314279453== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_"
--_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Luis,
________________________________ From: Luis Falcon Sent: Thursday, May 5, 2022 9:44 AM To: Yusif Suleiman Cc: General GNU Health discussion and help Subject: Re: [Health] Restore data to new installation
Good morning, Yusif!
On Wed, 4 May 2022 20:26:34 +0000 Yusif Suleiman wrote:
Although you could use any DB name, when doing a restore, the best is to use the same database name as in the original, because the attachments have the prefix of the DB.
Okay, I understand.
To create the db user associated to gnuhealth user, follow the same steps as in the installation guide See: https://en.wikibooks.org/wiki/GNU_Health/Installation#Creating_the_Database= _User
I create the db user gnuhealth following the steps as in wiki. # su - postgres -c "createuser --createdb --no-createrole --no-superuser gn= uhealth"
However, when I try to restore the data I still got the error message. # psql GNUTest backup_Fitrah_DB_2022-04-18_143054 psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5= 432" failed: FATAL: role "backup_Fitrah_DB_2022-04-18_143054" does not exi= st.
I believe, something is wrong with me. Maybe I still do not understand this= part. Yusuf.
Happy & healthy hacking! Luis
--_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
1">
color: rgb(0, 0, 0);" class=3D"elementToProof"> Dear Luis,
or:rgb(0,0,0)">
=3D"font-size:11pt">From: Luis Falcon <falcon-at-gnuhealth.org>r> Sent: Thursday, May 5, 2022 9:44 AM
To: Yusif Suleiman <yusifsuleiman-at-hotmail.com>
=3D"Calibri, sans-serif" color=3D"#000000" style=3D"font-size:11pt">Cc:<= /b> General GNU Health discussion and help <health-at-gnu.org>
=3D"font-size:11pt">Subject: Re: [Health] Restore data to new instal= lation
>
Good morning, Yusif!
On Wed, 4 May 2022 20:26:34 +0000
Yusif Suleiman <yusifsuleiman-at-hotmail.com> wrote:
Although you could use any DB name, when doing a restore, the best is
to use the same database name as in the original, because the
attachments have the prefix of the DB.
Okay, I understand.
To create the db user associated to gnuhealth user, follow the same steps as in the installation guide See: he_Database_User" data-auth=3D"NotApplicable">https://en.wikibooks.org/wiki= /GNU_Health/Installation#Creating_the_Database_UserI create the db user gnuhealth following the steps as in wiki.
# su - postgres -c "createuser= --createdb --no-createrole --no-superuser gnuhealth"
However, when I try to restore the data I still got the error message.=
# psql GNUTest backup_Fitrah_DB_202= 2-04-18_143054 psql: error: connection to server on socket "/var/run/postgresql/= .s.PGSQL.5432" failed: FATAL: role "backup_Fitrah_DB_2022-0= 4-18_143054" does not exist.
I believe, something is wrong with me. Maybe I still do not understand= this part. Yusuf.
Happy & healthy hacking! Luis
--_000_AM5P189MB05796D3B10A2F968834339DEBBC59AM5P189MB0579EURP_--
--===============1314279453== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline
_______________________________________________ Hangout mailing list Hangout-at-nylxs.com http://lists.mrbrklyn.com/mailman/listinfo/hangout
--===============1314279453==--
|
|