Cheat Sheet for Administrating a PostgreSQL Database/Server
PostgreSQL Interactive Terminal Postgresql is similar to MySQL in that it uses an interactive terminal. To gain access type the following as root su – postgres -c psql You’re now logged into the Postgresql interactive terminal and interacting with the local server. Common Shell Commands Dump a database. When dumping and restoring a … Read more