Well, here's what I use to snapshot the database every night:
/usr/bin/pg_dump -Ft -b dspace | gzip -9 > /var/lib/idea/db.tar.gz
Change the names and paths to suit your envorinment, of course. The
result should be suitable for loading with 'pg_restore'. It will
*not* include your database use
The all-time trusted tool for backup and restore is postgres' own
pg_dump and pg_restore
To see the command options:
pg_dump --help
pg_restore --help
It can be tricky to use because you have to put into a good combination
of flags. Some flags you may wish to use with pg_dump is -b and -Fc
Any
Another crisis averted :) I tried to export the database via Navicat's MS
Access format and it imported vi Navicat on the new box just fine (although
I'll have to re-assign primary keys, apparently). Before, I was trying to
export in a text delimited format, but it would mess up field lengths and
Hi Allen,
Thank you for the suggestion. I just would like to confirm whether it
applies to the situation where dspace version hasn't changed? I have dspace
1.5.1 on both machines. Postgres versions are slightly different (8.3.5-1
on the old and 8.3.6-2 on the new), but it probably isn't a signi
The db schema is changed while dspace version is changed. You errors may
be caused by version mismatch between dspace and db.
I suggest you re-create the old version db on the new machine, then run
the upgrade scripts provided by dspace to upgrade the db schema upto 1.5.1
Hope this helps.
Rega
Forgot to mention - I am running the latest versions of DSpace (1.5.1) and
PostgreSQL (8.3) on both machines. And also the latest Apache and Tomcat 6.
On Thu, Mar 19, 2009 at 6:26 AM, Stan Orlov wrote:
> Greetings!
>
> I have DSpace running on a Windows XP machine and am migrating it to a
> Wi
Greetings!
I have DSpace running on a Windows XP machine and am migrating it to a
Windows 2003 server with the same structure. Installation went smoothly,
jspui is accessible, but I can't properly transfer the PostgreSQL database.
I tried to dump it using command line, backup using pgAdmin III, b
7 matches
Mail list logo