[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-users] Backing up PHPgroupware
From: |
Brian Johnson |
Subject: |
Re: [Phpgroupware-users] Backing up PHPgroupware |
Date: |
Thu, 17 Apr 2003 20:30:54 +0000 |
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
:)