Once you have restored the database download via CLI (see the Related Articles section for reference articles), you can use this article for step-by-step instructions on how to query the database via CLI.
This section demonstrates you how to execute SQL statements against your newly restored database, and is not intended to be a guide on how to construct your own SQL statements.
You can refer to PostgreSQL: Documentation: 9.2: The SQL Language for an excellent introduction to SQL.
- This article covers all versions of Jive Custom.
- The commands in this article (and cross-reference articles) were written using PostgreSQL version 9.2.6
- This guide was written for the Mac OSX release of Postgres/pgAdmin; however, the steps should translate to Windows or Linux.
- Use the psql command to connect to your database:
test.user$ psql -h localhost -p 1111 -U postgres testdb
psqlis the name of the command we are running.
-hoption is the name of the host, which should be
localhostfor default installs.
-poption is the name of the port, which should be
1111for default installs.
-Uoption is the name of the user to connect as, which should be Postgres.
testdbis the name of the database to connect to. Replace this with the name of the database you restored your dump to.
- You can now execute SQL statements directly in the command line.