Re: Uploading and loading

Поиск
Список
Период
Сортировка
От Steve Poe
Тема Re: Uploading and loading
Дата
Msg-id 1124098605.14153.11.camel@amd64-laptop-spoe
обсуждение исходный текст
Ответ на Uploading and loading  (Sean Montague <couloir007@yahoo.com>)
Список pgsql-novice
Sean,

I am not sure what platform the database file is on, but that may not
matter at this point.

1) What, if any, error messages are you seeing from the Postgres?
2) if you have size limitations, have you considered compressing your db
dump file first?
3) If you have Putty installed, you should have access to scp as well
which would allow you to securely copy the db file without having to
depend on ftp. If not, download the full putty self-extracting files and
try again.


Steve Poe


On Sun, 2005-08-07 at 17:33 -0600, Sean Montague wrote:
> So far I've been relegated to phpPgAdmin to upload my data, but it has
> size limits, which I am exceeding.  So I was told to ftp the backup
> files, and use PuTTY, which I've been trying to do.  I'm getting
> connected, but don't know what to do next.  None of the postgreSQL
> commands are available.  Is there something I'm missing?  Any insight
> would be most appreciated.
>
> Sean
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match


В списке pgsql-novice по дате отправления:

Предыдущее
От: Jim Jarrett
Дата:
Сообщение: Suspend Referential Integrity?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SQL query question