On Wed, Jan 31, 2007 at 07:17:48PM +0200, David Baron wrote: > I have an openoffice spreadsheet 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 spreadsheet. 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
signature.asc
Description: Digital signature
