← Back to team overview

dhis2-devs team mailing list archive

Re: Postgres restore problem

 

Hi

I'm no expert, but... the dhis2demo.backup file is not is a dump
format. It is in plain text.

So you need to do something like this:
psql -d dbname -U username -f dhis2demo.backup

--
Morten

On Wed, May 4, 2011 at 1:40 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> Hi,
> I'm trying this on my server:
> pg_restore -i -d dhis2_demo -v dhis2demo.backup
> but all I get is this:
> pg_restore: [archiver] input file does not appear to be a valid archive
> Is this likely to be because I still have 8.4 on the server? If so, any tips
> on upgrading (I have lots of data on the server)?
> Knut
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


Follow ups

References