agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedBUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip
2+ messages / 2 participants
[nested] [flat]
* BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip
@ 2026-09-20 00:21 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2026-09-20 00:21 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: RobS.postgresql9@MailScreen.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip
@ 2026-09-20 13:02 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2026-09-20 13:02 UTC (permalink / raw)
To: RobS.postgresql9@MailScreen.com; pgsql-bugs@lists.postgresql.org
On Sun, 2026-09-20 at 00:21 +0000, PG Bug reporting form wrote:
> 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 [...]
You are complaining to the wrong project. The PostgreSQL documentation does
not seem to have anything about a sample database. You'll have to complain
to Neon.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-09-20 13:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-09-20 00:21 BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip PG Bug reporting form <noreply@postgresql.org>
2026-09-20 13:02 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox