pgAdminIII restore database issue

[Database Administrator]

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?

[Database Administrator]

Marek wrote:
> 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

[Database Administrator]

Laurenz Albe wrote:
>> 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

[Database Administrator]

Laurenz ,

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

I have no access to server via terminal :-(

[Database Administrator]

> The tar-Format is not just compressed SQL scripts.

I any way to create this strange tar/not-tar format having SQL written in
plain text?

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

No, I can't. First error, like for example a not existing table drop, stops
script execution. It's hard to correct by hand 200MB sized SQL script. If I
remember (I'm not sure) the same script executed from file works fine.
However I'm sure that SQL script executed via psql will not stop on first
error type as mentioned (which exactly is not error). Unfortunatelly I have
no access to psql.

[Database Administrator]

Marek wrote:
>> 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 -p -U -d -f

Yours,
Laurenz Albe

[Database Administrator]

> You can use it like this:
>
> psql -h -p -U -d -f

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