Thread: restoring from a dump

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

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

The other quick item to consider is whether or not your database is on a *nix system or a windows machine, and if your
workstationis *nix or windows.   

Cases/suggestions:
1. Windows workstation / *nix DB Server: use putty.exe to ssh into the DB server (a second option would be to use
PGAdmin,a GUI db management package for PostgreSQL) 
2. Windows workstation / Windows DB Server: use CMD.com and enter psql command line (may have to add "C:/Program
Files/PostgreSQLX.YY/bin"to your PATH).  Could also use PGAdmin in this case 
3. *nix client / *nix server: command line psql (ssh to server if not the same as your workstation)



________________________________________
From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] on behalf of CS DBA
[cs_dba@consistentstate.com]
Sent: Sunday, January 06, 2013 2:48 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from a dump

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin