pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pls help me
5+ messages / 2 participants
[nested] [flat]

* pls help me
@ 2006-03-01 10:26 sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 5+ messages in thread

From: sandhya @ 2006-03-01 10:26 UTC (permalink / raw)
  To: pgsql-admin

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 = lo_creat(conn, INV_READ | INV_WRITE);
if (lobjId == 0)
fprintf(stderr, "can't create large object\n");

lobj_fd = 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 = 0;
len = strlen(szContent);
while (len - nwritten > 0)
{
nbytes = lo_write(conn, lobj_fd, szContent, len - nwritten);
nwritten += nbytes;
}

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Fw: pls help me
@ 2006-03-01 11:56 sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 5+ messages in thread

From: sandhya @ 2006-03-01 11:56 UTC (permalink / raw)
  To: pgsql-admin




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 = lo_creat(conn, INV_READ | INV_WRITE);
if (lobjId == 0)
fprintf(stderr, "can't create large object\n");

lobj_fd = 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 = 0;
len = strlen(szContent);
while (len - nwritten > 0)
{
nbytes = lo_write(conn, lobj_fd, szContent, len - nwritten);
nwritten += nbytes;
}

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* pls help me
@ 2006-03-09 08:17 sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 5+ messages in thread

From: sandhya @ 2006-03-09 08:17 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>


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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pls help me
@ 2006-03-09 09:38 sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 5+ messages in thread

From: sandhya @ 2006-03-09 09:38 UTC (permalink / raw)
  To: Mohamed Fazil <mohdfazil_p_a@yahoo.com>; +Cc: pgsql-admin

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 ----- 
  From: Mohamed Fazil 
  To: sandhya 
  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 
  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 "<path>\pgsql\bin\pg_ctl.exe start -D ""<path>\pgsql\data" -l ""<path>\pgsql\pg_log.txt"" | "<path>\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 <sandhyar@amiindia.co.in> 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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Pls Help Me
@ 2006-12-23 05:22 sai <dsvvsai@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: sai @ 2006-12-23 05:22 UTC (permalink / raw)
  To: pgsql-admin

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)

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-12-23 05:22 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-01 10:26 pls help me sandhya <sandhyar@amiindia.co.in>
2006-03-01 11:56 Fw: pls help me sandhya <sandhyar@amiindia.co.in>
2006-03-09 08:17 pls help me sandhya <sandhyar@amiindia.co.in>
2006-03-09 09:38 Re: pls help me sandhya <sandhyar@amiindia.co.in>
2006-12-23 05:22 Pls Help Me sai <dsvvsai@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox