473,396 Members | 1,725 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Serverless/embedded PostgreSQL database

Hi All,

I am trying to connct to a serverless/embedded PostgreSQL database from a C# application using VS 2005. First of all, is this possible with PostgreSQL? I know this can be done with some other database providers (sqllite?). If anyone has connected to such a database using some other method/language I'd be greatful for the information.

Thank you in advance for any information.
May 16 '07 #1
6 12657
michaelb
534 Expert 512MB
Postgresql cannot be used in this manner. If you must use an embedded database look at the Berkeley Db, or CodeBase from Sequiter, or better yet do a Google search for "embedded database" or "open source embedded database"
May 17 '07 #2
Thank you for your reply. Unfortunately we have a product which comes with embedded PostgreSQL and I need to find a way to connect to the database, if possible. Or find another way to extract the information from the database. I have been googling for the past few days for some clue. But my search hasn't yielded anything fruitful yet.
May 18 '07 #3
michaelb
534 Expert 512MB
... we have a product which comes with embedded PostgreSQL
As it often happens this term - "embedded" - may have more than one meaning depending on the context.

Can you use Postgresql the way it's supposed to be used, with postmaster running and serving the clients?
May 18 '07 #4
Can you use Postgresql the way it's supposed to be used, with postmaster running and serving the clients?
I am honestly not sure if it can be done or not. But I tried to connect to PostgreSQL using some existing methods (ODBC, npgsql) from c# application assuming it to be a regular database server. However, I received errors with both mothods of connecting. With npgsql the error was something along the line of "server actively refused connection". And with ODBC it was more like "server doesn't support the version of method call". This makes me wonder whether a postmaster is running to serve client or not.
May 22 '07 #5
michaelb
534 Expert 512MB
Obviously you cannot connect to the database if server is not running. On Windows it can be setup as a service, of you prefer you can start it by hand.
On Unix the startup script can be called from the system boot scripts, or it can be started by hand.
Review these manuals, it may help you to get a better understanding of things involved:
http://www.postgresql.org/docs/8.2/static/runtime.html
http://www.postgresql.org/docs/8.2/s...ver-start.html
http://www.postgresql.org/docs/8.2/s...pp-pg-ctl.html

Once server is running you can verify it with psql,
something simple like psql -l will do.

When you confirm that server responds, then you can go on working through your client API.
May 22 '07 #6
Thanks for you input.
May 24 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

59
by: Jeff Bowden | last post by:
For ease of configuration and other reasons, I would like for my single-user GUI app to be able to use postgresql in-process as a library accessing a database created in the users home directory. ...
0
by: Ann Harrison | last post by:
Tom, Actually, I've never had a corrupted firebird database. There were two bugs in an older version of InterBase that produced income for me. The first was a failure to realize that a file had...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.