[GENERAL] Remote PostgreSQL database - C/C++ program / Unix / Required Libraries

Hello and thank you for reading my post. I would like to write a C/C++ program which targets a remote PostgreSQL database. I don't know what to install, which libraries to link to in this program. In more details: Given: 1.1) a PostgreSQL database db on a machine A, 1.2) a machine B. I would

[GENERAL] Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries

Me again. Sorry. This looks good too: Building libpq Programs: http://www.postgresql.org/docs/9.1/static/libpq-build.html But what do I need to install on B? Best regards. -- View this message in context:

[GENERAL] Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries

Thank you for your answer :) Adrian Klaver-4 wrote: My guess is you want is way to install the minimum necessary to write a C/C++ file against the Postgres libraries. Is this correct? Exactly. Adrian Klaver-4 wrote: If so you will need to either install the appropriate -dev package,

[GENERAL] Re: How to start several PostgreSQL clusters at boot time on a Debian OS

Hello Adrian, Yes, I am aware of it. I even used to use Debian pg_createcluster and other tools before. Even so, thank you for your comment. Best regards. -- View this message in context:

[GENERAL] How to start several PostgreSQL clusters at boot time on a Debian OS

Hello and thank you for reading my post. My question is about starting PostgreSQL clusters at boot time. The OS is Debian Wheezy. I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at http://www.postgresql.org/ftp/source/v9.3.5/. In a shell and logged as unprivileged_user (a

[GENERAL] Re: How to start several PostgreSQL clusters at boot time on a Debian OS

It's perfect. Thank you very much. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-OS-tp5823085p5823088.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via

Re: [GENERAL] Starting a cluster as a service

Hello Raghavendra, Sorry for the late answer, I couldn't test this properly before. That indeed solves the problem. Thank you and best regards. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Starting-a-cluster-as-a-service-tp5712728p5714759.html Sent from the PostgreSQL

Re: [GENERAL] Starting a cluster as a service

Hi again, I'm running PostgreSQL 9.1 under Windows XP. I'm still trying to set a proper logging system for a PostgreSQL cluster a_pg_cluster. In the cluster postgresql.conf configuration file, I uncommented logging_connector = on. When I stopped + started the service, I could see a pg_log

Re: [GENERAL] Starting a cluster as a service

Hello Thomas, Contrary to what you say, I provided command lines and messages (in case of failure). What is missing according to you? Thank you and best regards. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Starting-a-cluster-as-a-service-tp5712728p5713039.html Sent

Re: [GENERAL] Starting a cluster as a service

Hi again, It looks like the problem comes from the -l option I'm trying to set when I register the service. 1) If I register the cluster as a service in the following way: It works: the service is automatically started properly. 2) If I add the following option: and then try to start the

Re: [GENERAL] Starting a cluster as a service

Sorry. I added some raw tags so maybe this is the reason why you couldn't see half of my message. Hi again, It looks like the problem comes from the -l option I'm trying to set when I register the service. 1) If I register the cluster as a service in the following way:

[GENERAL] Starting a cluster as a service

Hello and thank you for reading my post. My problem is that I do not manage to start a PostgreSQL cluster as a Windows service. The OS is WinXP. - I've created a PostgreSQL cluster a_pgcluster with the associated port 5433. - Running cmd.exe under Windows as a_user, I can start and stop it

Re: [GENERAL] Default PostgreSQL server encoding - Change to unicode (utf8)

Hello. Thank you for your answer. I used the lt;rawgt; and lt;/rawgt; tags, this is probably the reason why you couldn't see the messages... Thank you for the two links. I read this (in the second one): On Windows, however, UTF-8 encoding can be used with any locale. yet I still have some

[GENERAL] Default PostgreSQL server encoding - Change to unicode (utf8)

Hello, Thank you for reading my post. When I run the command: I get the following messages: I would like the cluster (and the databases) encoding to be unicode (UTF8). What can I do? Can I set the default encoding I want for the whole PostgreSQL server somewhere? Thank you for helping and