Re: how can I tell it's postgresql data? - Mailing list pgsql-novice

From Mike Grommet
Subject Re: how can I tell it's postgresql data?
Date
Msg-id 20030205204221.16114.qmail@web10102.mail.yahoo.com
Whole thread Raw
In response to how can I tell it's postgresql data?  (Ricardo Anguiano <anguiano@codesourcery.com>)
Responses Re: how can I tell it's postgresql data?
List pgsql-novice
Could they possibly be database dump files?  just text
files filled with the sql to build and populate
various tables?

you might be able to do a "more" of one of the
files...

Its an idea anyway... and I'm only guessing since I
have no idea what the files look like...


--- Ricardo Anguiano <anguiano@codesourcery.com>
wrote:
>
> Greetings,
>
> I have recently been given some files and told they
> were "postgre SQL
> database" files.  I have a couple of questions.
>
> I am new to databases and postgresql.  I have
> managed to install
> postgresql-7.2.2, initialize it, and get postmaster
> started under
> FreeBSD 4.7-RELEASE.
>
> Question #1: How can I tell if I have actual
> "postgresql database"
>              files?  The files have no extension.
> The `file` command
>              reports the files are "MS-Windows true
> type font .ttf"
>              files.
>
> db_restore doesn't like the files:
>
>         pg_restore: [archiver] input file does not
> appear to be a
>         valid archive
>
> Question #2: If these are database files, how can I
> get the data back
>              in the database?
>
> Any help will be appreciated.
>
> Thanks,
> --
> Ricardo Anguiano
> http://www.codesourcery.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

pgsql-novice by date:

Previous
From: Ricardo Anguiano
Date:
Subject: how can I tell it's postgresql data?
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: How can I speed up with query?