[ADMIN] problem with postgresql7.2 installation

2002-02-15 Thread Srinivasa Rao Chava
Hi, I'm trying to install postgresql7.2 on susOS. When I used gmake command to build it, it is giving the following error. /usr/ucb/cc: language optional software package not installed Below is some of the output generated with gmake. /bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00

[ADMIN] User access to start and stop postmaster

2002-02-15 Thread Andy Marden
I'm running a batch load on PostgreSQL 7.1.3 on Linux as a given OS user. As part of this, I want to restart postmaster with -i access removed and at the end, restart with -i added on (denying network access during the load process). Trouble is, it seems that I have to be the postgres user to do t

[ADMIN] How to include plpgsql in table pg_language

2002-02-15 Thread Pam Wampler
I am trying to get a trigger/function to work & I think I need to use the plpgsql to do that -- but I keep getting errors that the plpgsql is not in the table pg_language -- What do I need to do to be able to use plpgsql? I am running 7.1.3 thanks Pam ---(end of broadca

Re: [ADMIN] problem with postgresql7.2 installation

2002-02-15 Thread Tom Lane
[EMAIL PROTECTED] (Srinivasa Rao Chava) writes: > /bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 > /usr/perl5/5.00503/ExtUtils/xsubpp -typemap > /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs > Pg.c > cc -c -I. -I../../../src/interfaces/libpq -I../../../src/include

[ADMIN] Constant file growth.

2002-02-15 Thread Alexandre Carmel-Veilleux
Hello I have noticed that my postgresql database sees a constant growth to some of the system files: 184M17112 Database=# select relname from pg_class where relfilenode = 17112; relname - pg_attribute_relid_attnam_index (1 r

Re: [ADMIN] How to include plpgsql in table pg_language

2002-02-15 Thread Stephan Szabo
On Fri, 15 Feb 2002, Pam Wampler wrote: > I am trying to get a trigger/function to work & I think I need to use the > plpgsql to do that -- > but I keep getting errors that the plpgsql is not in the table pg_language > -- > What do I need to do to be able to use plpgsql? Use the createlang scri

Re: [ADMIN] Porting to Win2000

2002-02-15 Thread Andy Ruhl
On Thu, 14 Feb 2002, Linda Fousek wrote: > I am installing postgresql on a win2000 machine. I have installed cygwin and > cygipc, and I'm getting the following error when trying to run ./configure > > loading cache ./config.cache > checking host system type ... i686-pc-cygwin > checking which tem

[ADMIN] problem with postgresql 7.2 recovery

2002-02-15 Thread Srinivasa Rao Chava
Hi I have installed postgresql 7.2. I took the backup with pg_dumpall in postgresql7.1.3 and I tried to restore it in postgresql7.2 with the following command. psql -d template1 -f pgbackups. it is not restoring anything except creating databases, users, but no objects. Below is the full text of

Re: [ADMIN] How to include plpgsql in table pg_language

2002-02-15 Thread Marco Tulio
> I am trying to get a trigger/function to work & I think I need to use the > plpgsql to do that -- > but I keep getting errors that the plpgsql is not in the table pg_language > -- > What do I need to do to be able to use plpgsql? > > I am running 7.1.3 > > thanks > Pam > on console, as p

Re: [ADMIN] hanging psql session while granting...

2002-02-15 Thread Marco Tulio
> hello , >Am facing a problem (strange or not, am not sure). > When i loginto psql as user x > and execute "Grant select on to " > it was hanging... am not able to grant any of the tables to any of the users > available. > > I cud grant tables of another user to other user... > > How c

[ADMIN] error when running make

2002-02-15 Thread Linda Fousek
I'm getting the following error when I run the make command on Windows2000: ... pg_passwd.o(.text+0x763):pg_passwd.c:undefined reference to 'crypt' collect2: ld returned 1 exit status make[3]: ***[pg_passwd] Error 1 make[3]: ***leaving directory '/usr/src/postgresql-7.2/src/bin/pg_passwd' make[2]

Re: [ADMIN] problem with postgresql 7.2 recovery

2002-02-15 Thread Tom Lane
[EMAIL PROTECTED] (Srinivasa Rao Chava) writes: > Hi I have installed postgresql 7.2. I took the backup with pg_dumpall > in postgresql7.1.3 and I tried to restore it in postgresql7.2 with the > following command. I think the thing you need to fix is: > psql:pgbackups:80: ERROR: stat failed on

Re: [ADMIN] error when running make

2002-02-15 Thread Tom Lane
Linda Fousek <[EMAIL PROTECTED]> writes: > I'm getting the following error when I run the make command on Windows2000: > ... > pg_passwd.o(.text+0x763):pg_passwd.c:undefined reference to 'crypt' > collect2: ld returned 1 exit status > make[3]: ***[pg_passwd] Error 1 Difficult to tell much when yo