Re: Getting started with Postgres or MySQL

On Wed, Jan 31, 2007 at 07:17:48PM +0200, David Baron wrote:
I have an openoffice spread*** from which I want to generate two related
tables. I have tried most everything installed.

Stuff from OpenOffice will generate a database with table entries named by the
first line in the spread***. This can, indeed, be queried, sort of.

I would like to get this data into a Postgres or MySQL database. Using
pgadmin3, I cannot get a connection connected. Does not accept my password.
Their docs cited Debian problems here and recommended md5 authorization.
Tried that. No avail. One can also simply say trust (localhost only). No
avail.

How do I get started here?

First. Please do not use MySQL, unless you don't care about your data.

Second, you do know that PostgreSQL users and system users are separate.
Have you created a user account in PostgreSQL? You can do this using
the command line program and this documented quite well at
http://postgresql.org/docs along with lots of other things.

As far as it not accepting your password, what do the errors in the logs
say?

Regards,

-Roberto
--
Roberto C. Sanchez
http://people.connexer.com/~roberto
http://www.connexer.com

Attachment: signature.asc
Description: Digital signature

Quantcast