Re: [ADMIN] psql won't stayed connected

Hi Tom, Below is an extract from a truss of the psql login, looks fine to me, I used the same source to build the Solaris client as I used for building the linux server, I have also installed the client on a separate Linux server and get the same results. I've tried using ident,md5 and trust

Re: [ADMIN] [PORTS] PostgreSQL Upgrade recommendations

moving to pgsql-admin which is much more appropriate for this type of post On Monday 09 August 2004 07:03, Andrew Parkyns wrote: > Hi, > I've just joined this morning and I wonder if anyone could help? I'd like > some opinions / war stories / suggestions/ recommendations whatever on > PostgreSQL u

Re: [ADMIN] psql won't stayed connected

"Kevin Izzet" <[EMAIL PROTECTED]> writes: > Below is an extract from a truss of the psql login, looks fine to me, Not really. Here we have the successful connection to the server: > 937:send(4, "\0\0\0 #\003\0\0 u s e r".., 35, 0)= 35 > 937:sigaction(SIGPIPE, 0xFFBEEAC8, 0xFFBEEB48)

Re: [ADMIN] psql won't stayed connected

Hi Tom, Nope nothing silly, just trying to get a command line connection.. Am I maybe missing some kind of default logicals ? Am I correct in thinking that apart from compiling the client from source I don't need to modify any of the conf files ? The fact that I get the same result from a L

Re: [ADMIN] [PORTS] PostgreSQL Upgrade recommendations

Thanks also to Tom and Robert - excellent advice thanks very much. I will now do as suggested & check out the version release notes - for 7.4 latest patch, and plan for upgrade to this version for the immediate future. We will probably be most interested in looking at 8.1 + as the next port so wi

[ADMIN] Minimal required to run psql on remote machine

Hi, I'd like to run psql on a remote machine. For security, there won't be login access granted for ssh sessions but we'd like to test various SPs and so forth. What is the minimum I have to install on to the remote machine so that I can connect with psql -h remote ? Cheers Mike -

[ADMIN] Update from 7.3.3 to 7.3.6

Hi, We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red Hat). However, we are having a number of problems importing the database schema. Some of the SPs are written in TCL and it would seem that the library has changed. In the dump of the schema we have (comments removed for brevi

Re: [ADMIN] psql won't stayed connected

"Kevin Izzet" <[EMAIL PROTECTED]> writes: > Am I maybe missing some kind of default logicals ? Darn if I know. > The fact that I get the same result from a Linux Client as a Solaris > client may point to something I've configured wrongly.. I could believe that on Solaris but on Linux it's v

Re: [ADMIN] Update from 7.3.3 to 7.3.6

"Mike Bell" <[EMAIL PROTECTED]> writes: > We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red > Hat). However, we are having a number of problems importing the database > schema. Some of the SPs are written in TCL and it would seem that the > library has changed. > ERROR: stat fai

Re: [ADMIN] psql won't stayed connected

Ok  get to the Donkey Ears for this week..   :-( We run all our apps from a central Linux HA service, when we add a new app we add a new link via a wrapper which allows the app to choose the correct OS and path for running that app The default for the apps is to have an & at the end

Re: [ADMIN] Update from 7.3.3 to 7.3.6

Tom, Thanks for that. It appears that the tcl support is there. However, the lib now appears to be called: ./usr/lib/libpgtcl.so Is this the same? I couldn't find documentation concerning the change in file. If so then can I just edit the schema? Cheers Mike -Original Message- From:

[ADMIN] Log message: "recycled transaction log file..."

Hello, Sorry if this is a too basic or is a FAQ. I've done some research but it's still unclear if this is something I should be concerned about. Running PostgreSQL 7.4.2 on Solaris 8. I'm getting a lot of the following messages in my log file: LOG: recycled transaction log file "00020

Re: [ADMIN] Update from 7.3.3 to 7.3.6

"Mike Bell" <[EMAIL PROTECTED]> writes: > It appears that the tcl support is there. However, the lib now appears > to be called: > ./usr/lib/libpgtcl.so > Is this the same? No, it's not the same at all. That is a client-side library. [ digs in RPM specfile ... ] Oh, I misspoke. It looks like p

Re: [ADMIN] Log message: "recycled transaction log file..."

Bill Chandler <[EMAIL PROTECTED]> writes: > Running PostgreSQL 7.4.2 on Solaris 8. I'm getting a > lot of the following messages in my log file: > LOG: recycled transaction log file "00020003E" This is normal behavior. At some point we'll probably knock down the priority of those messag

Re: [ADMIN] Update from 7.3.3 to 7.3.6

Yes, I believe so: rpm -qa | grep -i postgresql rh-postgresql-contrib-7.3.6-1_ts2.eduserv_1.rhel3 rh-postgresql-libs-7.3.6-1_ts2.eduserv_1.rhel3 rh-postgresql-tcl-7.3.6-1_ts2.eduserv_1.rhel3 rh-postgresql-devel-7.3.6-1_ts2.eduserv_1.rhel3 rh-postgresql-server-7.3.6-1_ts2.eduserv_1.rhel3 rh-postgr

Re: [ADMIN] Update from 7.3.3 to 7.3.6

"Mike Bell" <[EMAIL PROTECTED]> writes: > Yes, I believe so: > rpm -qa | grep -i postgresql > ... > rh-postgresql-pl-7.3.6-1_ts2.eduserv_1.rhel3 That one should certainly have installed pltcl.so for you. Perhaps you could use rpm -ql to find out where it put it? I suspect that overall this is a

Re: [ADMIN] psql won't stayed connected

In article <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: >If you have strace or ktrace or similar on the Solaris machine, tracing >psql's kernel calls might be revealing. What you want to watch for is >whether psql is exiting with the connection still open, or whether it >receives an E