Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hsbX0-00007B-Jd for pgsql-sql@arkaria.postgresql.org; Tue, 30 Jul 2019 23:27:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hsbWz-0000Tw-0E for pgsql-sql@arkaria.postgresql.org; Tue, 30 Jul 2019 23:27:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hsbWy-0000Nn-AW for pgsql-sql@lists.postgresql.org; Tue, 30 Jul 2019 23:27:44 +0000 Received: from mail-eopbgr740092.outbound.protection.outlook.com ([40.107.74.92] helo=NAM01-BN3-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hsbWu-0002uP-5P for pgsql-sql@lists.postgresql.org; Tue, 30 Jul 2019 23:27:42 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=jWShDOOqj7JUm0eKeamAvMeoi7a04ak4tysTJssSsjb5SPkNLS9OpmSXPVT104LlNw+fJQfoOlSaMUu546EUSnJfwhcqtwmo9K/lNRPN1QQdVeEVtThClQ9NffK5vAUGUDoiaMxVQanKUA5OUJ+yNJjeJNXVOteByIs5h0Wmm/zCUCt4JQWQLHGKCLrz0kvG6yGOD1CE6kxMmYS4dQPpzPkBU38DlFpPu0VBL7rq4BGqNPxHktK/Y1ZaMJAUCCKuuyVfU9f27t6aO6P+SCwOQzREbyoKgMzchFqnnSZWI20H9SFgoYNqfM1lY4tlK2GD3C+ae8NiIsCs4KKvD7YifQ== 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-SenderADCheck; bh=LG6wxai5vylyYFhrxak1Q/OjUBuQ4gXRL2/zbBJjBhw=; b=PwrYVtosDc3NgqshsDMV0uv0iiqK0OXUssthNYCEVB7BEvFIUJZjBdyU3ViD35TQuZoCQUPDKTfJyt4xbHOWfFZwilLwbOle+GuO6GfuRmZmjIBDyAm2uN4dltlvFY2r+iDpGibLc1pf3zOCmAG0XKp+dhB/9JL9bm+3mIRuGiZOS7UOKbPI15Y1EgfrP0hdB/sSfRlkRFr5UmIlNoVqXsshv1Z7y9g+MtcDTMg0vun8ouKP3b8yf5p7sU3juk9MvVijsfTwZV0+jF38Wzx9HNzUNHJekc+hccnqPdmss2DQ0wMl7xfwuEY8YeDPcG7STQ08sYg1b+Ewh32kHZenwA== ARC-Authentication-Results: i=1; mx.microsoft.com 1;spf=pass smtp.mailfrom=seattleschools.org;dmarc=pass action=none header.from=seattleschools.org;dkim=pass header.d=seattleschools.org;arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=seattleschools.org; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=LG6wxai5vylyYFhrxak1Q/OjUBuQ4gXRL2/zbBJjBhw=; b=GYK/YHVnuNgiGJetD/gNiq6BDWVa2ArC9VXlt/CmzXyyLqPklD1Vv12f9Dtsz5mPj9W8FI7ieOeOAbX5tFEYZ626yBicO96XF0kBa8SL/N0xQh06N46ssj5G42Pozxz8IC7faTzpZQYL/lOwZOmjEtQEbc3D+HctbzPQ+upaq3Y= Received: from MWHPR0401MB3515.namprd04.prod.outlook.com (10.167.162.142) by MWHPR0401MB3516.namprd04.prod.outlook.com (10.167.162.143) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2115.15; Tue, 30 Jul 2019 23:27:36 +0000 Received: from MWHPR0401MB3515.namprd04.prod.outlook.com ([fe80::9d21:53a8:446b:7628]) by MWHPR0401MB3515.namprd04.prod.outlook.com ([fe80::9d21:53a8:446b:7628%3]) with mapi id 15.20.2115.005; Tue, 30 Jul 2019 23:27:36 +0000 From: "Cao, Xiaowei" To: "pgsql-sql@lists.postgresql.org" Subject: install sample database error Thread-Topic: install sample database error Thread-Index: AdVHLkKwvss0e9izQ/W8T5QDAbQhww== Date: Tue, 30 Jul 2019 23:27:36 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=xicao@seattleschools.org; x-originating-ip: [216.186.64.172] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 8dd461cc-7228-4ac5-50b0-08d71545816c x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(4652040)(8989299)(4534185)(4627221)(201703031133081)(201702281549075)(8990200)(5600148)(711020)(4605104)(1401327)(2017052603328)(7193020);SRVR:MWHPR0401MB3516; x-ms-traffictypediagnostic: MWHPR0401MB3516: x-ms-exchange-purlcount: 2 x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:9508; x-forefront-prvs: 0114FF88F6 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(4636009)(39850400004)(396003)(366004)(376002)(136003)(346002)(199004)(189003)(52294003)(316002)(790700001)(3846002)(6116002)(786003)(6916009)(7736002)(33656002)(66066001)(486006)(81156014)(81166006)(74316002)(8936002)(4743002)(2351001)(2906002)(25786009)(8676002)(14454004)(476003)(186003)(256004)(14444005)(2501003)(3480700005)(68736007)(102836004)(52536014)(4744005)(6506007)(53936002)(26005)(5640700003)(66476007)(66556008)(5660300002)(64756008)(6436002)(66946007)(66446008)(99286004)(6306002)(54896002)(76116006)(86362001)(7696005)(55016002)(71200400001)(71190400001)(478600001)(9686003)(158833001)(130980200001);DIR:OUT;SFP:1102;SCL:1;SRVR:MWHPR0401MB3516;H:MWHPR0401MB3515.namprd04.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: seattleschools.org does not designate permitted sender hosts) x-ms-exchange-senderadcheck: 1 x-microsoft-antispam-message-info: 1Cs87Q53rYzbqP3x5bQaxv1Scjd5XzS2OBa5E1Mwz2sDr6MQ/Bo+c9zxVqZS0coKp4r5D4PFguitDGe3gwLyWYoOkHmqcHxc1X3wD8f7kKT8KRvwFlYOoUD7GFlBZIbuECPJgH3PT9Px00PeYANxGsQxQt+WAh2o1Oqk5wQSUsOrAlpP1TfSF/V+mknGXihQ47s6v4F5kwK2Lue++zZJTWHXOgGAES/6I6sLS7w1k8mxm3xVUix8HSKfqSiEodZ3aL9WqsQQDbTA5ExWPVFSdSYPrjMW9gYAUSXJLdlclsSJhSuWvBVUhzI+g/DpJjlSFoIE3NzBpZQ7B/wZLWGxH4qTWBgEQlGLcT1JViYi6MBf+c87yK/ER/B1XIsv6RSARjVh/ujpSIZ1lPx6sZiLyqVovHfacBdHnsDzdZ+a0sE= Content-Type: multipart/alternative; boundary="_000_MWHPR0401MB351540C74EB0D1DB8367B15ECBDC0MWHPR0401MB3515_" MIME-Version: 1.0 X-OriginatorOrg: seattleschools.org X-MS-Exchange-CrossTenant-Network-Message-Id: 8dd461cc-7228-4ac5-50b0-08d71545816c X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Jul 2019 23:27:36.2481 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: d431d158-6074-4832-8783-51ea6f6dd227 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: xicao@seattleschools.org X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR0401MB3516 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_MWHPR0401MB351540C74EB0D1DB8367B15ECBDC0MWHPR0401MB3515_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I tried to download the postgresql sample database dvdrental to install on = ubuntu. This is a test environment. I got some errors while running the restore.sql in the downloaded file. Psql : restore.sql 1015: Error: could not open file $$PATH$$/3077.dat for r= eading: NO such file or directory. And the same error for all other dat files... I guessed first the permission issue, I tried to give the file directory t= he widest privilege like 777, but still has this error. Database and tables are created, but there are no rows in table. What could be wrong, what does $$PATH$$ mean? Thanks, Anne Cao --_000_MWHPR0401MB351540C74EB0D1DB8367B15ECBDC0MWHPR0401MB3515_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I tried to download the postgresql sample database d= vdrental to install on ubuntu.  This is a test environment.=

I got some errors while running the restore.sql in t= he downloaded file.

Psql : restore.sql 1015: Error: could not open file = $$PATH$$/3077.dat for reading: NO such file or directory.

And the same error for all other dat files…

 

I guessed  first the permission issue, I tried = to give the file directory the widest privilege like 777, but still has thi= s error.

Database and tables are created, but there are no ro= ws in table.

 

What could be wrong, what does $$PATH$$ mean?

 

Thanks,

 

Anne Cao

--_000_MWHPR0401MB351540C74EB0D1DB8367B15ECBDC0MWHPR0401MB3515_--