Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database name correction when creating postgres_air #2160

Open
johnomage opened this issue Sep 15, 2024 · 0 comments
Open

Database name correction when creating postgres_air #2160

johnomage opened this issue Sep 15, 2024 · 0 comments

Comments

@johnomage
Copy link

In this part for postgres_air database

CREATE DATABASE postgres_air;

Navigate to the directory where you downloaded the source file, and run the following command:

pg_restore -d postgresql://[user]:[password]@[neon_hostname]/postgres_air -Fc postgres_air_2023.backup -c -v --no-owner --no-privileges

Database objects are created in a postgres_air schema rather than the public schema.

Connect to the postgres_air database:

psql postgresql://[user]:[password]@[neon_hostname]/wikipedia

This last script should be

psql postgresql://[user]:[password]@[neon_hostname]/postgres_air

link direct to text

Thanks for the walkthrough.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant