Re: [ADMIN] POSTGRES.. NEED HELP

On Mon, Sep 7, 2009 at 8:48 PM, Richy Gerard wrote: > While using embedded sql in postgres, > a. Installed the ecpg library > b. after installation i couldn't compile the program prog1.c > ERROR: > ri...@ubuntu:~/Desktop$ ecpg prog1.pgc > ri...@ubuntu:~/Desktop$ cc -c prog1.c > prog1.c:3:22: erro

Re: [ADMIN] POSTGRES.. NEED HELP

Hi, Richy Gerard writes: > prog1.c:3:22: error: ecpgtype.h: No such file or directory > prog1.c:4:21: error: ecpglib.h: No such file or directory > prog1.c:5:23: error: ecpgerrno.h: No such file or directory > prog1.c:6:19: error: sqlca.h: No such file or directory > prog1.pgc:1: error: expected

Re: [ADMIN] server disk space

Brian Modra wrote: > Great Idea, thanks, However, I notice that the postmaster seems idle, > according to top, only 1% of the CPU at most... is it busy with IO > maybe? Still seems strange that it sits at 0, or 1% ... > > Nothing else is running on the system... > > But when I use ps: > > postg

[ADMIN] POSTGRES.. NEED HELP

While using embedded sql in postgres, a. Installed the ecpg library b. after installation i couldn't compile the program prog1.c ERROR: ri...@ubuntu:~/Desktop$ ecpg prog1.pgc ri...@ubuntu:~/Desktop$ cc -c prog1.c prog1.c:3:22: error: ecpgtype.h: No such file or directory prog1.c:4:21: error: ecpgli

Re: [ADMIN] PostgreSQL crashes

Hi, It just happened again, now with 8.4, so it seems like the fix mentioned below didn't really help. Does anyone have an idea what could cause it? As a reminder, the log is below. Thanks, Moshe. 2009-09-07 12:15:49 IDTLOG: server process (PID 60524) exited with exit code 128 2009-09-07 12:1