Re: Uploading and loading - Mailing list pgsql-novice

From Steve Poe
Subject Re: Uploading and loading
Date
Msg-id 1124098605.14153.11.camel@amd64-laptop-spoe
Whole thread Raw
In response to Uploading and loading  (Sean Montague <couloir007@yahoo.com>)
List 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 by date:

Previous
From: Jim Jarrett
Date:
Subject: Suspend Referential Integrity?
Next
From: Tom Lane
Date:
Subject: Re: SQL query question