Hi,
Just wondering if anyone has used Berkley sockets ever.
I'm aiming at establishing a socket connection between my Postgres database server (using the shared objects that i dynamically load)
and a Unix server.
What would be the best thing to use for such a thing in Postgres scenario?
Thanks,
ocess through a shared object dynamicall loaded in postgres.
Berkley sockets is the socket API in unix that uses
Don't know if there's a better way to do it.
~Jas
On 9/13/06, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Tue, Sep 12, 2006 at 07:52:08PM -0400, J S B wrote:
Thanks alot Tony.
just wondering if the same can be done with C
~Jas
On 9/13/06, Tony Caduto <[EMAIL PROTECTED]> wrote:
J S B wrote:> I don't want to connect to the postgres database.>> The scenario is something like this.
>> Postgres database has to initiate some
What exactly is this LISTEN/NOTIFY?Is it some function in socket programing or some part of postgres?~JasOn 9/15/06, Martijn van Oosterhout
<kleptog@svana.org> wrote:On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote:
> Thanks alot Tony.> just wondering if the same can be do
Hi,
I'm trying to make my database a client for an external unix based deamon process acting as a server.
I was thinking of writing some clinet application in a shared object in
the database (same as what we do with socket programing) that
does other Db
related activities as well.
Would be a righ
Hi,I'm trying to start my postgres server using#> pg_ctl start -D /usr/local/pgsql/abcand get an error like:invalid data in PID file "/usr/local/pgsql/abc/postmaster.pid"
can anyone comment whats wrong.My postmaster.pid file is empty at the time when i run this command.Regards,Jas
i never touched it. when i opened it to check the stuff inside, found it empty.What should i do now?On 10/11/06, Martijn van Oosterhout <
kleptog@svana.org> wrote:On Wed, Oct 11, 2006 at 02:50:59PM -0400, J S B wrote:
> I'm trying to start my postgres server using>> #> pg_
another postmaster already running on port 5432? If not, wait a few seconds and retry.FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
Can you please tell me what is this all about?JasOn 10/11/06, J S B <[EMAIL PROTECTED]> wrote:
i never touched it. when i op
NT: Is another postmaster already running on port 5432? If not , wait a few seconds and retry.WARNING: could not create listen socket for "*"
FATAL: could not create any TCP/IP socketsOn 10/11/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"J S B" <[EMAIL PROTECTED]>
g a cyclic problem.Don't know how to get rid of it now.Thanks,JasOn 10/11/06, Tom Lane <
[EMAIL PROTECTED]> wrote:"J S B" <
[EMAIL PROTECTED]> writes:> There was some problem with postmaster.pid file, so i just removed it.Without bothering to stop the old postmaster first, I t
Hi,I took a back up of my database and restored it in a new DB..When I'm trying to connect to the new DB from a client machine using ECPG connection techniques, it says newDB doesn't exist.There's another DB in the same DB server and if I try and connect to that DB then it doesn't cry over anything
]> wrote:
J S B wrote:> Hi,> I took a back up of my database and restored it in a new DB..When I'm> trying> to connect to the new DB from a client machine using ECPG connection> techniques, it says newDB doesn't exist.
> There's another DB in the same DB server a
The only diff b/w the two DBs is that the one getting connected has ACL value as blank and the one that doesn't get connected has the same ACL property values = {}On 10/13/06,
Shane Ambler <[EMAIL PROTECTED]> wrote:
J S B wrote:> Hi,> I took a back up of my database and restor
7; is all upper.
Thanks,
Jas
On 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"J S B" <[EMAIL PROTECTED]> writes:> The user in the client machine is usrxyz (a unix user role) and user role
> that owns newDB is userxyz (a db user role)I notice you keep spelling i
ECTED]> wrote:
"J S B" <[EMAIL PROTECTED]> writes:> well, newDB is the name of the database and that what I'm tryin to connect.> I'm tryin to keep it the same case in ECPG code as it is in the Database.
> Do u mean to say that combination of upper and lower case i
Hi,I've made a client and a server program in C using socket library.The client is in the postgres database server and Server is on some other machine.My goal is to compile the client as a shared object, load it dynamically in postgres (in a function), execute that postgres function in which this s
Hi,I have the following scenario:-1. There's a function in the postgres datbase that when executed calls a shared object (dynamically loaded).2. The shared object is a Client (made using socket library) which connects to a server (coded again using socket library) hosted on some other machine.
3. T
Can I have a function (language sql) returning SETOF more than one table?Thanks,Jas
18 matches
Mail list logo