Thread: Uploading and loading

Uploading and loading

From
Sean Montague
Date:
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

Re: Uploading and loading

From
Steve Poe
Date:
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