Re: how can I tell it's postgresql data?

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(at)codesourcery(dot)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