PostgreSQL: Difference between revisions
No edit summary |
|||
| Line 19: | Line 19: | ||
*https://askubuntu.com/questions/371737/install-postgresql-why-is-initdb-unavailable | *https://askubuntu.com/questions/371737/install-postgresql-why-is-initdb-unavailable | ||
*https://superuser.com/questions/513386/setting-up-postgresql-gives-error-sudo-initdb-command-not-found | *https://superuser.com/questions/513386/setting-up-postgresql-gives-error-sudo-initdb-command-not-found | ||
==Command line== | |||
psql -e db < example.sql | |||
Revision as of 2018-08-30T12:04:11
Name
- postgresql / PostgreSQL
- postgresql.org
- pgsql - PL/pgSQL
- mod_pgsql
- pdo_pgsql
- postgres
- psql
Creating cluster
https://www.postgresql.org/docs/10/static/creating-cluster.html
"/usr/local/pgsql/data or /var/lib/pgsql/data are popular"
- in Ubuntu 'apt-get install postgresql' creates /var/lib/postgresql/
initdb not found
- https://askubuntu.com/questions/371737/install-postgresql-why-is-initdb-unavailable
- https://superuser.com/questions/513386/setting-up-postgresql-gives-error-sudo-initdb-command-not-found
Command line
psql -e db < example.sql