Mark Forums Read

pgAdminIII restore database issue

Go Back

comp.databases.postgresql comp.databases.postgresql

Reply

Page 1 of 5

1

#1

Old

Marek

Posts: n/a

pgAdminIII restore database issue - 09-04-2008 , 05:26 AM

Hi,

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain sql
script to readable for pgAdminIII version?

Reply With Quote

#2

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#3

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#4

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#5

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#6

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#7

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#8

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#9

Old

Laurenz Albe

Posts: n/a

Re: pgAdminIII restore database issue - 09-08-2008 , 02:40 AM

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

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

Yours,
Laurenz Albe

Reply With Quote

#10

Old

Laurenz Albe

Posts: n/a

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

Laurenz Albe <invite (AT) spam (DOT) to.invalid> wrote:

Quote:

I would like to modify by hand plain text dump of database (in SQL). I've
done all changes and now my intention is to use pgAdminIII to restore
database. I found in documentation that TAR files are supported so I packed
my sql script using Total Commander. Unfortunatelly button OK in restore
window remains grayed. Does anybody know what is needed to convert plain
sql script to readable for pgAdminIII version?

The tar-Format is not just compressed SQL scripts.

Can't you simply execute the SQL script with pgAdmin III?

I had second thoughts:

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.

Yours,
Laurenz Albe

Reply With Quote

Reply

Page 1 of 5

1

« 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.