Re: [Phpgroupware-users] Backing up PHPgroupware

[Brian Johnson]

Look into pg_dumpall and pg_dump

I think there was a change in the date format but I forget which versions of
postgresql that applied to

pg_dumpall creates a text file with the appropriate SQL commands to recreate 
the db
including table values .. so you can load it in a text editor and use a
search/replace function if needed

Then (I forget the specifics) you do something like psql -U user template1 <
test.dump to receate the db after setting up the new version




Chris Weiss (address@hidden) wrote:
>
>with mysql there's a mysqldump util that will give you list of sql commands 
>that can
>be run on the new server to recreate the database on the new server
>
>Rett Walters (address@hidden) wrote:
>>
>>Hello all:
>>
>>Does anyone out there have any advice or tools on backing up and moving a
>>phpgroupware install on a linux system and moving it to a new linux install 
>>on a
>>different box?  I am using Postgres on RH Linux 7.2 and wish to move it to a 
>>RH 8.0
>>server.  The postgresql docs on backing up databases don't seem to be to 
>>friendly,
>>In fact it seems that there is no way to upgrade postgres data tables after 
>>the
>>packages are upgraded; it seems that several steps are needed before hand. 
>>Anyone
>>out there have experience in this?
>>
>>Any suggestions or help would be greatly appreciated.
>>
>>Rett Walters
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

--
Brian Johnson

This is where my witty signature line would be if I bothered to edit this line 
:)