On 1/5/13 1:54 PM, J Rouse wrote:
Stupid person here. Just got PostgresSQL today. Have text dump
file. Need to restore.
I think I need to use psql, but do not even know how to get to it.
Need exact instructions on where to enter the command line, setting up
paths if necessary, etc.
Jim
to restore from a text (sql) file:
1) ensure you have a target database:
- you might need to set your path, i.e. you need to know where psql is
- if you did an rpm / package install it's probably in /usr/bin
# connect to the cluster (database instance):
$ psql
# then create your target database:
postgres# create database my_target_db;
Then exit from psql (exit; or ctl-d)
postgres# exit;
2) import the sql text file
- cd to the directory where the text file is:
$ cd /home/postgres/Downloads
- Import the file
$ psql -ef ./import_file.sql my_target_db
You could also point to the sql file without being in the directory:
$ psql -ef /home/postgres/Downloads/import_file.sql my_target_db
Note the -f is the psql flag to import (or run) a specified sql file
from the command line, the -e flag says to push all SQL statements as
well as normal output to STDOUT
See the psql command docs for more info here:
http://www.postgresql.org/docs/9.2/interactive/app-psql.html
Hope this helps,
/Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
