From sandhyar@amiindia.co.in Wed Mar 1 10:20:51 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E09C99DC896 for ; Wed, 1 Mar 2006 06:20:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48965-08 for ; Wed, 1 Mar 2006 06:20:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 112B89DC88D for ; Wed, 1 Mar 2006 06:20:42 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k21AFOnM015738 for ; Wed, 1 Mar 2006 15:45:24 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 5DFF3332668for ; Wed, 1 Mar 2006 15:45:24 +0530 (IST) Message-ID: <00d801c63d1a$976d8920$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: pls help me Date: Wed, 1 Mar 2006 15:56:24 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00D5_01C63D48.B0EA1BB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:26.71068 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.082 required=5 tests=[AWL=0.080, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.082 X-Spam-Level: X-Archive-Number: 200603/4 X-Sequence-Number: 20761 This is a multi-part message in MIME format. ------=_NextPart_000_00D5_01C63D48.B0EA1BB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, In my application i need to create a file dynamically and load it into = DB. So.....I have created one object at run time .....and trying to open it = inorder to write the content into it..... But lo_open is returning -1(-ve value). where i am doing mistake pls tell me. lobjId =3D lo_creat(conn, INV_READ | INV_WRITE); if (lobjId =3D=3D 0) fprintf(stderr, "can't create large object\n"); lobj_fd =3D lo_open(conn, lobjId, INV_WRITE); //My application failed at this point..what i am missing here ? if (lobj_fd < 0) { fprintf(stderr, "can't open large object %d\n",lobjId); } lo_lseek(conn, lobj_fd, 0, SEEK_SET); nwritten =3D 0; len =3D strlen(szContent); while (len - nwritten > 0) { nbytes =3D lo_write(conn, lobj_fd, szContent, len - nwritten); nwritten +=3D nbytes; } ------=_NextPart_000_00D5_01C63D48.B0EA1BB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

In my application i need to create a file dynamically and load it = into=20 DB.

So.....I have created one object at run time .....and trying = to open=20 it inorder to write the content into it.....
But lo_open is returning -1(-ve=20 value).

where i am doing mistake pls tell me.

lobjId =3D lo_creat(conn, INV_READ | INV_WRITE);
if = (lobjId =3D=3D=20 0)
fprintf(stderr, "can't create large object\n");
 
lobj_fd =3D lo_open(conn, lobjId, INV_WRITE);
//My application failed at this point..what i = am=20 missing here ?
if = (lobj_fd <=20 0)
{
fprintf(stderr, "can't open large object %d\n",lobjId);
}
lo_lseek(conn, lobj_fd, 0, SEEK_SET);
nwritten =3D 0;
len =3D strlen(szContent);
while = (len - nwritten=20 > 0)
{
nbytes =3D lo_write(conn, lobj_fd, szContent, len - = nwritten);
nwritten +=3D nbytes;
}
------=_NextPart_000_00D5_01C63D48.B0EA1BB0-- From sandhyar@amiindia.co.in Wed Mar 1 11:51:24 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DA1429DC951 for ; Wed, 1 Mar 2006 07:51:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63457-03 for ; Wed, 1 Mar 2006 07:51:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id C900E9DC896 for ; Wed, 1 Mar 2006 07:51:15 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k21BjfoD001713 for ; Wed, 1 Mar 2006 17:15:42 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id EF285332665for ; Wed, 1 Mar 2006 17:15:38 +0530 (IST) Message-ID: <018201c63d27$34f26ec0$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: Fw: pls help me Date: Wed, 1 Mar 2006 17:26:38 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_017F_01C63D55.4BFC0580" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:27.06173 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.083 required=5 tests=[AWL=0.081, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.083 X-Spam-Level: X-Archive-Number: 200603/5 X-Sequence-Number: 20762 This is a multi-part message in MIME format. ------=_NextPart_000_017F_01C63D55.4BFC0580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, In my application i need to create a file dynamically and load it into = DB. So.....I have created one object at run time .....and trying to open it = inorder to write the content into it..... But lo_open is returning -1(-ve value). where i am doing mistake pls tell me. lobjId =3D lo_creat(conn, INV_READ | INV_WRITE); if (lobjId =3D=3D 0) fprintf(stderr, "can't create large object\n"); lobj_fd =3D lo_open(conn, lobjId, INV_WRITE); //My application failed at this point..what i am missing here ? if (lobj_fd < 0) { fprintf(stderr, "can't open large object %d\n",lobjId); } lo_lseek(conn, lobj_fd, 0, SEEK_SET); nwritten =3D 0; len =3D strlen(szContent); while (len - nwritten > 0) { nbytes =3D lo_write(conn, lobj_fd, szContent, len - nwritten); nwritten +=3D nbytes; } ------=_NextPart_000_017F_01C63D55.4BFC0580 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 

Hi,

In my application i need to create a file dynamically and load it = into=20 DB.

So.....I have created one object at run time .....and trying = to open=20 it inorder to write the content into it.....
But lo_open is returning -1(-ve=20 value).

where i am doing mistake pls tell me.

lobjId =3D lo_creat(conn, INV_READ | INV_WRITE);
if = (lobjId =3D=3D=20 0)
fprintf(stderr, "can't create large object\n");
 
lobj_fd =3D lo_open(conn, lobjId, INV_WRITE);
//My application failed at this point..what i = am=20 missing here ?
if = (lobj_fd <=20 0)
{
fprintf(stderr, "can't open large object %d\n",lobjId);
}
lo_lseek(conn, lobj_fd, 0, SEEK_SET);
nwritten =3D 0;
len =3D strlen(szContent);
while = (len - nwritten=20 > 0)
{
nbytes =3D lo_write(conn, lobj_fd, szContent, len - = nwritten);
nwritten +=3D nbytes;
}
------=_NextPart_000_017F_01C63D55.4BFC0580-- From sandhyar@amiindia.co.in Thu Mar 9 08:39:43 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8C7709DCA03 for ; Thu, 9 Mar 2006 04:39:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04872-08 for ; Thu, 9 Mar 2006 04:39:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id C35D59DC806 for ; Thu, 9 Mar 2006 04:39:36 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k298XgAr010972 for ; Thu, 9 Mar 2006 14:03:42 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id CCF9133267B; Thu, 9 Mar 2006 13:36:48 +0530 (IST) Message-ID: <003501c64352$006cd6f0$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: pls help me Date: Thu, 9 Mar 2006 13:47:56 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0030_01C64380.129EA6E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:89.34031 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.904 required=5 tests=[AWL=-0.737, HTML_IMAGE_ONLY_12=1.639, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.904 X-Spam-Level: X-Archive-Number: 200603/92 X-Sequence-Number: 20849 This is a multi-part message in MIME format. ------=_NextPart_000_0030_01C64380.129EA6E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable My Postgres server is not connecting now.I am working on windows . I am getting the following error message. E:\PostgreSql\bin>Execution of PostgreSQL by a user with administrative = permissi ons is not permitted. The server must be started under an unprivileged user ID to prevent possible system security compromises. See the documentation for more information on how to properly start the server. and when i tried to start from the service..i am getting the following = message box. Pls help me..I need it very much Thanks&Regards, Sandhya ------=_NextPart_000_0030_01C64380.129EA6E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
My Postgres server is not connecting now.I am = working on=20 windows .
I am getting the following error = message.

E:\PostgreSql\bin>Execution of PostgreSQL by a user with=20 administrative permissi
ons is not
permitted.
The server must = be=20 started under an unprivileged user ID to prevent
possible system = security=20 compromises.  See the documentation for
more information on how = to=20 properly start the server.
and when i tried to start from the service..i am getting the = following=20 message box.
Pls help me..I need it very much
 
3D""
 
Thanks&Regards,
Sandhya
------=_NextPart_000_0030_01C64380.129EA6E0-- From sandhyar@amiindia.co.in Thu Mar 9 09:38:13 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 615C29DC806 for ; Thu, 9 Mar 2006 05:38:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22141-02 for ; Thu, 9 Mar 2006 05:38:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id EFECA9DC82E for ; Thu, 9 Mar 2006 05:38:04 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k299RsH5022157; Thu, 9 Mar 2006 14:58:01 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 88A54332670; Thu, 9 Mar 2006 14:57:45 +0530 (IST) Message-ID: <008701c6435d$4eede1b0$cd00000a@sandhyar> From: "sandhya" To: "Mohamed Fazil" Cc: "Postgres" References: <20060309091619.57798.qmail@web31015.mail.mud.yahoo.com> Subject: Re: pls help me Date: Thu, 9 Mar 2006 15:08:49 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0082_01C6438B.602A2E10" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.102 required=5 tests=[AWL=0.100, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.102 X-Spam-Level: X-Archive-Number: 200603/94 X-Sequence-Number: 20851 This is a multi-part message in MIME format. ------=_NextPart_000_0082_01C6438B.602A2E10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you Fazil..... Is there any specific reason that we need to go c:\WINDOWS\system32 I have already user existing for this Postgres.....But when i open psql = to template1 it is clsoing the window..?Why is this happening so? What happened to the user already we created... U mean to say i have to give this at command prompt. ----- Original Message -----=20 From: Mohamed Fazil=20 To: sandhya=20 Sent: Thursday, March 09, 2006 2:46 PM Subject: Re: [ADMIN] pls help me Hi, I am not an expert in PG, still i can help u to some extend as i have = successfully deployed pg8.1.1 using both installer and no installer on = Win XP,2K,2003. To solve your issue=20 1. cretae a user on your local system. 2. Use runas to run pg_ctl using the user created Eg batch file: @echo off chdir c:\WINDOWS\system32 runas /user:SYSNAME\postgres "\pgsql\bin\pg_ctl.exe start -D = ""\pgsql\data" -l ""\pgsql\pg_log.txt"" | "\sanur pwd pause In the above eg sanur is a utility used myself for piping the pwd into = runas as it will ask externally. You can download it from = http://www.commandline.co.uk/sanur_unsupported/index.html Also go through the Following FAQ link f or ur further queries http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#1.1 Also u have to copy libpq.dll either in %system32% or in PG bin = folder. Regards Mohamed Fazil sandhya wrote: My Postgres server is not connecting now.I am working on windows . I am getting the following error message. E:\PostgreSql\bin>Execution of PostgreSQL by a user with = administrative permissi ons is not permitted. The server must be started under an unprivileged user ID to prevent possible system security compromises. See the documentation for more information on how to properly start the server. and when i tried to start from the service..i am getting the = following message box. Pls help me..I need it very much Thanks&Regards, Sandhya -------------------------------------------------------------------------= ----- Yahoo! Mail Use Photomail to share photos without annoying attachments. ------=_NextPart_000_0082_01C6438B.602A2E10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you Fazil.....
Is there any specific reason that we need to = go
c:\WINDOWS\system32
I have already user existing for this = Postgres.....But when i=20 open psql to template1 it is clsoing the window..?Why is this happening=20 so?
What happened to the user already we = created...
U mean to say i have to give this at command=20 prompt.
 
 
----- Original Message -----
From:=20 Mohamed=20 Fazil
To: sandhya
Sent: Thursday, March 09, 2006 = 2:46=20 PM
Subject: Re: [ADMIN] pls help = me

Hi,
 
I am not an expert in PG, still i can help u to some extend as i = have=20 successfully deployed pg8.1.1 using both installer and no installer on = Win=20 XP,2K,2003.
 
To solve your issue
1. cretae a user on your local system.
2. Use runas to run pg_ctl using the user created
Eg batch file:
@echo off
chdir c:\WINDOWS\system32
runas /user:SYSNAME\postgres=20 "<path>\pgsql\bin\pg_ctl.exe start -D ""<path>\pgsql\data" = -l=20 ""<path>\pgsql\pg_log.txt"" | "<path>\sanur = pwd
pause
 
In the above eg sanur is a utility used myself for piping the pwd = into=20 runas as it will ask externally. You can download it from http:/= /www.commandline.co.uk/sanur_unsupported/index.html
 
Also go through the Following FAQ link f or ur further = queries
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#1.1
 
Also u have to copy libpq.dll either in %system32% or in PG bin=20 folder.
 
Regards
Mohamed Fazil
 
 


sandhya <sandhyar@amiindia.co.in>=20 wrote:
 
My Postgres server is not connecting now.I am = working on=20 windows .
I am getting the following error = message.

E:\PostgreSql\bin>Execution of PostgreSQL by a user with = administrative permissi
ons is not
permitted.
The server = must be=20 started under an unprivileged user ID to prevent
possible system = security=20 compromises.  See the documentation for
more information on = how to=20 properly start the server.
and when i tried to start from the service..i am getting the = following=20 message box.
Pls help me..I need it very much
 
3D""
 
Thanks&Regards,
Sandhya


Yahoo! Mail
Use=20 Photomail to share photos without annoying=20 attachments. ------=_NextPart_000_0082_01C6438B.602A2E10-- From dsvvsai@gmail.com Sat Dec 23 05:48:44 2006 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B95EB9FA5BA for ; Sat, 23 Dec 2006 01:48:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 08258-07-2 for ; Sat, 23 Dec 2006 01:48:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 085DE9FA9BD for ; Sat, 23 Dec 2006 01:22:19 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so3831681nfb for ; Fri, 22 Dec 2006 21:22:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=bclBRjF48Dnn1q/uIzbxzyvmVPQJZKRMjygX57dYLGkR8Sc02Mp2ZSTD00FfquaNSsis27GKOFXZvdC35u76TIBkFzY6XxsmMXWmsYHKih/3Hk0FyeXMT+HZsd2k0tkncZZPU+O8M4Jaooro7Rc+ZtEXwB2kCLYYFwr6mEmjVd0= Received: by 10.82.138.6 with SMTP id l6mr212138bud.1166851338854; Fri, 22 Dec 2006 21:22:18 -0800 (PST) Received: by 10.82.184.18 with HTTP; Fri, 22 Dec 2006 21:22:18 -0800 (PST) Message-ID: <386ee0dd0612222122j14e8773fh5cfd13dd156374ca@mail.gmail.com> Date: Sat, 23 Dec 2006 10:52:18 +0530 From: sai To: pgsql-admin@postgresql.org Subject: Pls Help Me MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_58459_6791953.1166851338836" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.376 tagged_above=0 required=5 tests=BAYES_50, HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200612/355 X-Sequence-Number: 24147 ------=_Part_58459_6791953.1166851338836 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Sir I am sai iam working in IEG(Hyderabad) as a programmer, *My project specifications are * *Language: *C#.Net and ASP.Net *RAM: *256 *Processor: *P4 *Hard Disk: *80 GB *DataBase: *Postgresql-8.1(Downloaded from internet) There is a problem in connection through LAN it is not giving any error, just it is refreshing the window so would you please give the suggestions to how to connect the DB properly in LAN or WAN and also please the proper software to install in my system,for this as we need any licenced version to purchase pls give the suggestions to me and also my project includes GIS little bit.Reply as soon as possible. Thanking you With Regards dsvvsai(09392857889) ------=_Part_58459_6791953.1166851338836 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Sir
I am sai iam working in IEG(Hyderabad) as a programmer,
My project specifications are
Language: C#.Net and ASP.Net
RAM: 256
Processor: P4
Hard Disk: 80 GB
DataBase: Postgresql-8.1(Downloaded from internet)
 
 
There is a problem in connection through LAN
it is not giving any error, just it is refreshing the window
so would you please give the suggestions to how to connect the DB properly in LAN or WAN and also please the proper software to install in my system,for this as we need any licenced version to purchase pls give the suggestions to me
and also my project includes GIS little bit.Reply as soon as possible.
 
Thanking you
With Regards
 
dsvvsai(09392857889)
------=_Part_58459_6791953.1166851338836--