Re: install sample database error

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