From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
Subject: | Re: install sample database error |
Date: | 2019-07-31 06:16:29 |
Message-ID: | 3728498d-fc28-4cc1-2fad-37f716eaad60@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Cao, Xiaowei schrieb am 31.07.2019 um 01:27:
> 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 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 this error.
>
> Database and tables are created, but there are no rows in table.
>
> What could be wrong, what does $$PATH$$ mean?
I assume you are referring to the sample database from:
http://www.postgresqltutorial.com/load-postgresql-sample-database/
You can't restore that sample database using psql, you need to use pg_restore.
As described in the link above, you only need to unzip the ZIP archive, that gives you a .tar file which you do NOT need to unpack.
Assuming you did already create the dvdrental database, you can restore the backup using:
pg_restore -U postgres -d dvdrental /path/to/dvdrental.tar
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Cao, Xiaowei | 2019-07-31 16:28:37 | RE: install sample database error |
Previous Message | Cao, Xiaowei | 2019-07-30 23:27:36 | install sample database error |