[ADMIN] unsubscribe

Missed your favourite TV serial last night? Try the new, Yahoo! TV. visit http://in.tv.yahoo.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [ADMIN] cannot connect using terminal nor pgaccess

also try using -i option along with other options. else all seems to be fine regards, Rajesh. --- Jaume Teixi <[EMAIL PROTECTED]> wrote: > $ psql -d template1 -U postgres > psql: Peer authentication failed for user 'postgres' > > > $ psql -d template1 -U postgres -h localhost -p 5432 > psql: I

[ADMIN] postgres bombs for continous selects....

Hi there, I am using postgres6.5.3, 7.0.2, 7.0.3 versions in three different systems. All the systems serve continous web requests that query postgres for data. It is around 25 - 30 requests per second. The database is also not big. Infact it is only 1Mb with 12 tables. Postgres process is

[ADMIN] Re: [BUGS] LockReplace: xid table corrupted

ECTED]> wrote: > Dronamraju Rajesh <[EMAIL PROTECTED]> writes: > > database:- Postgres 6.5.2 ( pl dont suggest to > upgrade > > to 7.0.2. once this problem is solved. then i can > do > > testing of my app with postgres 7.0.2) > > If you update to 7.0.3, you'l

[ADMIN] LockReplace: xid table corrupted

Hi There, I have production systems running postgres for 24x7x365. But suddenly it stops serving the requests but the postmaster does not die. I cant do select or even say pgsql until i kill postmaster clear shared memory segments and restart it again. for all the forth coming requests it s

Re: [ADMIN] Postgresql on Solais 7

go through the documentation on the postgresql.org site. you will get a good amount of info there. anyhow i have postgres working well on solaris 7. you will have to compile postgres source code and install it on your sparc. you will need gcc compiler, make, gdb or gdbm, gzip,bash which yo

[ADMIN] vacuum....errors...killing my PRODUCTION servers

Hi all, My first doubt is that for how many updates do we have to vacuum the database. I have a production server running postgres database with around 2 rows which is very small. I continously redirect http requests which do a select with joins of nearly 6 tables. I also do 150 updat

[ADMIN] why does postmaster get down ???

Hi there, I have mod-perl apache sending continous web requests to postmaster. My system is a linux box with dual CPU with 1GB RAM. I have started the postmaster with the following command line:- postmaster -i -N 256 -B 512 >>/usr/local/pgsql/server.log 2>&1 & I have also tried with

Re: [ADMIN] V7.0.3 on Solaris 2.7

hi jean, after installing postgres before doing initdb add the following statements in the /etc/system file and relink the kernel or give 'touch /etc/reconfigure' and reboot the system. forceload: sys/semsys forceload: sys/shmsys set shmsys:shminfo_shmmax=268435456 set shmsys:shminfo_shmseg=20 s

Re: [ADMIN] v7.0.3 on Solaris 2.7

hi jean, this problem crops up in all postgres installations on solaris. as postgres installation find ar,lex,lorder and other commands while installation. these commands are there in /usr/ccs/bin on all solaris machines. so include this in the PATH environment variable. after adding it try 'whic

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

jimi, you have to install modules like DBD-pg, DBD-CSV, DBI etc, which u get from www.cpan.org all the best try ur luck after installing them. i hope u''' be on target!!! regards Rajesh Intercept Consulting - INDIA --- Jimi Thompson <[EMAIL PROTECTED]> wrote: > I am trying to get Postgres to

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

jimi, you have to install modules like DBD-pg, DBD-CSV, DBI etc, which u get from www.cpan.org all the best try ur luck after installing them. i hope u''' be on target!!! regards Rajesh Intercept Consulting - INDIA --- Jimi Thompson <[EMAIL PROTECTED]> wrote: > I am trying to get Postgres to

[ADMIN] pg_atoi: error in "template1": can't parse "template1"

Dear all, I have installed postgres 6.5.1 on my RedHat Linux box. The installation went smooth without any problems. Now when i run initdb I got errors. I have seen the Postgres FAQ also and have ensured that all the directories i,e /usr/local/pgsql, /home/postgres etc are owned by postgres su

[ADMIN] how can I mirror a postgres database

Hi all, I am having postgres6.5 installed on a remote linux server. Now i have installed the same scenario in a local machine. Now i want to update my local machine with any transaction or changes made in remote machine. something like a oracle parallel server. where if one machine breaks dow

[ADMIN] shmget fails for min buffers of postmaster also on solaris 7 .....

Dear All, I have installed postgres 7.0.2 on solaris 7 on an intel based machine. But, when I am trying to run the postmaster( the database startup) with minimum buffers also it gives the following error IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1104

[ADMIN] libpq errors when makeing postgres 7.0.2...

Dear All, I have downloaded gcc and make from www.sunfreeware.com in pkgadd format for solaris 7. Then I have installed them using pkgadd successfully. Now Iam trying to install postgres 7.0.2. But i get the following errors when i say make:- make[2]: Entering d

[ADMIN] libpq error when installing postgres 7 on solaris 7???

Dear All, I am trying to install postgres 7.0.2 on solaris 7. I have d/l'ed and installed gcc and gmake which are needed for postgres. Then I have run ./configure as given in install file after untaring it. Then I have run gmake and while executing this command i got the following erro

Re: [ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

Hi, Thanks for the reply. But I have some doubts. they are the following:- 1.) At sunfreeware.com there are two gcc files in gz format. There is a make utility also but is it the gmake what postgres uses. 2.) Even the gzip is in gz format. Now how do I unzip it and once I start installing t

[ADMIN] gzip, gcc, gmake utilities to install POSTGRES on solaris ???

Hello everyone, I am need to install postgres ver 7 database on solaris 7. can anybody pl suggest me where do i get these modules. Pl don't suggest me that it is from sunfreeware.com because i did not get these from there. I'll just put the utilities in order i need. kindly suggest where do

[ADMIN] what utilities do i need for postgres on solaris 7 ??

Hello Everyone, I have an Intel system with solaris 7 installed on it. Now I have d/l'ed postgres 6.5.1 to install it on my system. 1.) What all the utilities are needed before I start compiling and installing the postgres s/w?. I mean to say utilities like gmake. But I could no

[ADMIN] What do i need before compiling postgres on solaris 7

Hi There, I am trying to compile postgres 7 on solaris 7. Kindly tell me what all do I need before compiling the postgres software. What is the process to compile and install the postgres 7 on solaris 7. Awaiting for an acknowledgement. Thanks in advance for all the help. Thanks & Reg