Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well):

LibreOffice Base data source selection

The following syntax (localhost:5432=<database name>; database name worktime) doesn't work:

enter image description here

When I try to test the connection on the next page, I get the following error:

Error in database URL 'sdbc:postgresql:localhost:5432=localhost':
invalid connection option "localhost:5432"

What is the correct syntax for the datasource URL?

share|improve this question
    
I may not ask an SU question especially for that, so I ask you personnally: what do you do when you plug Libre Office into Postgresql ? what kind of help, usefulness does this association offer ? Is it only for editing the content of the database ? –  Stephane Rolland Jan 28 '13 at 13:09
2  
@StephaneRolland: LibreOffice provides a graphical interface for input and editing of data in the tables as well as a query builder, among other features that make interfacing with the database easier. –  DragonLord Jan 28 '13 at 14:46

2 Answers 2

up vote 12 down vote accepted

Ever Forward will answer your question:

This is not an Internet URL, but it functions similarly. You now need to tell LibreOffice to connect to a specific database on a specific computer:

dbname=mydb host=localhost

Use the name of your database in the dbname part. I used localhost for the host part, since PostgreSQL is on the same computer, but I would need to change that in the event that I want to connect from a remote computer.

share|improve this answer
2  
Can you give a summary of the blog post? Standalone links aren't very useful and could become useless altogether if the linked page disappears. –  DragonLord Feb 18 '12 at 16:36
    
It works! Thanks, but once again, please give a summary of the blog post. –  DragonLord Feb 18 '12 at 17:03
    
sorry... is my poor english! I'm spanish... –  txindoki Feb 18 '12 at 18:41
    
I've added the relevant excerpt from the blog post. –  DragonLord Feb 21 '12 at 16:25

I know this Q is closed.. but here is more data information for someone who may stumble across this topic.

Another form of datasource URL is in the format of:

dbname=postgres hostaddr=127.0.0.1 port=5433 user=db_user password=libreoffice

I needed the above, because the default port used by LibreBase is 5432, but I needed 5433.

This URL format is discussed at http://ask.libreoffice.org/question/459/generic-form-of-url-for-postgresql/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.