Mark Forums Read

pgAdminIII restore database issue

Go Back

comp.databases.postgresql comp.databases.postgresql

Reply

Page 5 of 5

5

#41

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 01:39 AM

Marek <marek1967 (AT) spam (DOT) interia.pl> wrote:

Quote:

A plain text dump is probably not something you can restore with
pgAdmin III since it makes use of psql syntax; you can probably only
restore it with psql.

I have no access to server via terminal :-(

You don't need shell access.

You can install the PostgreSQL client on your local machine, and it will
talk to the server.

If you are on Windows, just download the Windows installer package from
http://www.postgresql.org/download/windows and install only the client.

If you have pgAdmin III on the machine, maybe you already have psql
installed!

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump>

Yours,
Laurenz Albe

Reply With Quote

#42

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#43

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#44

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#45

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#46

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#47

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#48

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

#49

Old

Marek

Posts: n/a

Re: pgAdminIII restore database issue - 09-10-2008 , 06:20 AM

Quote:

You can use it like this:

psql -h <server host> -p <port> -U <username> -d <database name> -f <dump

Of course, I forgot about this solution :-)))
Thanks a lot Laurenz!

Reply With Quote

Reply

Page 5 of 5

5

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.