Re: Working between Windows and Unix

Erick Papadakis wrote:
> Hello:
>
> I am working on Windows and Unix with Postgresql (newbie, so please be
> kind). I use phppgadmin on both platforms. Windows is my local
> machine. Linux (CentOS as usual) is the cpanel thing that my hosting
> provider offers.
>
> Basically this setup works well and I am learning the ropes. But the
> problem is with exporting data and structure. Phppgadmin does not
> allow exporting to SQL of the database on Windows platform. I see this
> error:
>
>
> --------------QUOTE--------------------
> <br />
> <b>Notice</b>:  Undefined offset:  1 in
> <b>D:\Code\phppg\dbexport.php</b> on line <b>75</b><br />
> <br />
> <b>Notice</b>:  Undefined offset:  1 in
> <b>D:\Code\phppg\dbexport.php</b> on line <b>78</b><br />
> Dumping of complex table and schema names on Windows is not supported.
> --------------END QUOTE--------------------
This usually means the output of pg_dump -i is not working correctly.
Have you got the correct path for pg_dump on your server?
Is pg_dump available on your server (where phpPgAdmin is running)?

You will need to edit conf/config.inc.php and set the correct path for
pg_dump, once you've done that, you should get the correct output.
>
>
> Failing this, what else can I do? How can I simply take all my data
> and structure from here and put it up?
>
> I also want this method to be fast because I have a table with about
> 2.5 million rows (I know it is nothing compared to other discussions
> that people post here, but it is a lot for my machine).
>
> Many thanks!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>