sql-ledger-users

[SL] MOVE SERVER WHIT DIFFERENT VERSION OF POSTGRESQL

[Ricardo G. T. <ri...@so...>]

I am working now in local server with the version 2.8.14 and
PostgreSQl 7.4.19 and want to do a backup  and restore it in a vps
when i have PostgreSQL 8.1 or 8.3 I am not very sure still and the
same SQL-Ledger's version. I think to do a support with pg_dump
(pg_dump-Fc) in the local server and one pg_restore in the new server,
what problem exists with the change of PostgreSQL's versions that
could fall ill in SQL-Ledger ?

Regards.

Ricardo Granados

Re: [SL] MOVE SERVER WHIT DIFFERENT VERSION OF POSTGRESQL

[Armaghan S. <sa...@le...>]

On Fri, May 9, 2008 at 12:29 PM, Ricardo Granados Tiznado
<ri...@so...> wrote:
> I am working now in local server with the version 2.8.14 and
> PostgreSQl 7.4.19 and want to do a backup  and restore it in a vps
> when i have PostgreSQL 8.1 or 8.3 I am not very sure still and the
> same SQL-Ledger's version. I think to do a support with pg_dump
> (pg_dump-Fc) in the local server and one pg_restore in the new server,
> what problem exists with the change of PostgreSQL's versions that
> could fall ill in SQL-Ledger ?

1. There should not be any problem restoring 2.8.14 backup into a
newer postgresql versions.

2. psql is enough to restore sql-ledger backup (after uncompressing
your backup if it is compressed)

Regards
Armaghan

Re: [SL] MOVE SERVER WHIT DIFFERENT VERSION OF POSTGRESQL

[Paul T. <pt...@wa...>]

Make sure to save all templates, users and other directories to say a usb
stick as well, just in case.
Those are NOT included in the sql_dump iirc.

2008/5/9 Armaghan Saqib <sa...@le...>:

> On Fri, May 9, 2008 at 12:29 PM, Ricardo Granados Tiznado
> <ri...@so...> wrote:
> > I am working now in local server with the version 2.8.14 and
> > PostgreSQl 7.4.19 and want to do a backup  and restore it in a vps
> > when i have PostgreSQL 8.1 or 8.3 I am not very sure still and the
> > same SQL-Ledger's version. I think to do a support with pg_dump
> > (pg_dump-Fc) in the local server and one pg_restore in the new server,
> > what problem exists with the change of PostgreSQL's versions that
> > could fall ill in SQL-Ledger ?
>
> 1. There should not be any problem restoring 2.8.14 backup into a
> newer postgresql versions.
>
> 2. psql is enough to restore sql-ledger backup (after uncompressing
> your backup if it is compressed)
>
> Regards
> Armaghan
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>