agora inbox for pgsql-bugs@postgresql.org  

help / color / mirror / Atom feed

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: RobS.postgresql9@MailScreen.com
Subject: BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip
Date: Sun, 20 Sep 2026 00:21:01 +0000
Message-ID: <19706-434738bedb25cd02@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      19706
Logged by:          Robert Simpson
Email address:      RobS.postgresql9@MailScreen.com
PostgreSQL version: 18.6
Operating system:   macOS
Description:        

The instructions at
https://neon.com/postgresql/getting-started/install-postgresql-macos has a
link to this page:
"https://neon.com/postgresql/getting-started/postgresql-sample-database";
which redirects to
"https://neon.com/postgresql/getting-started/sample-database"; and also
points to the file containing the sample database at
"https://neon.com/postgresqltutorial/dvdrental.zip";. The "sample-database"
page says "The database file is in zipformat ( dvdrental.zip) so you need to
extract it to dvdrental.tar ..." which is correct - after downloading and
extracting the .zip file, there is only one file, the dvdrental.tar file, in
that dvdrental.zip archive file.

However, the instructions on the "getting-started" page mentioned above says
"Fifth, download the sample database and unzip it. You’ll get a directory
with many files." where there is only that one dvdrental.tar file there. You
_can_ extract the .tar file (tar -xf) and get a directory with "many" files.
After that, if you continue with the instructions, "Eighth, select the
directory as the Format (1), the directory that contains sample database as
the Filename (2), and postgres as the Role name (3), and click the Restore
button." and restore the dvdrental database using the directory containing
the individual files, or even if you restore the database from the .tar file
and Refresh the database in the navigation tree, there are no tables in the
database.

I _was_ able to restore the schema with "psql -U postgres -d dvdrental -f
restore.sql" but then the tables are not populated with any data.

The instructions skip from the "Fifth" step to the "Seventh" step. Is there
a "Sixth" step missing there? I thought that would be the step to extract
the "many" files from the .tar file (so the part mentioning "many" files
should have been part of that step rather than the "Fifth" step), but that
didn't work for me - as mentioned, there were no tables after restoring the
database using either method.

view thread (2+ messages)  latest in thread

Message-ID: <19706-434738bedb25cd02@postgresql.org>
Permalink:  ../19706-434738bedb25cd02@postgresql.org/
Also on:    postgresql.org/message-id/19706-434738bedb25cd02@postgresql.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, RobS.postgresql9@MailScreen.com
  Subject: Re: BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip
  In-Reply-To: <19706-434738bedb25cd02@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox