[ADMIN] problem with setting PATH variable

2004-08-19 Thread Pradeepkumar, Pyatalo (IE10)
Hi all, I have installed PostgreSQL 7.4.3 on LINUX 7.2 and some other machines have LINUX 8.0. The problem is that every time my machine restarts the postmaster stops...i have to manually restart the postmaster serviceis there any way to automate the postmaster service. I did follow the steps

Re: [ADMIN] long term persistent tunnels

2004-08-19 Thread Tom Lane
David Bear <[EMAIL PROTECTED]> writes: > Asume I have another server called web1 that will be connecting to db1 > for data base operations. If I setup an ssh tunnel should I be aware > of any problems with 1) spontaneously dropped connections...2) long > term time out -- 3)other? In theory the co

[ADMIN] service did not start anymore

2004-08-19 Thread Van den bosch
Hello, Yesterday i installed postgresql 8 on a windows xp sp1 machine without a firewall. After a couple of minutes the installation was done. I did a small test in delphi without any problems. Great! This morning after a reboot of my computer, the service don't start anymore. I did no changes to

Re: [ADMIN] can't authenticate pg admin

2004-08-19 Thread Martin J. Brown, Jr.
On Fri, 13 Aug 2004 14:54:36 -0400, Tom Lane wrote: > "Martin J. Brown, Jr." <[EMAIL PROTECTED]> writes: >> Other db users authenticate fine, only the admin fails. > > That seems very odd. The only theory that comes to mind is that you've > set a password expiration time for that account in pg_s

[ADMIN] PostgreSQL Logs in Win32 Version from pgInstaller

2004-08-19 Thread Thomas Wegner
Hello where can i found the Log files from this Version? - Thomas Wegner Cabrio Meter - The Weather Plugin for Trillian http://trillian.wegner24.de/cabriometer ---(end of broadcast)--- TIP 7: don't forget

[ADMIN] PostgreSQL as a DDBMS

2004-08-19 Thread Rodrigo Bonfa
Friends, I would like to know if PostgreSQL can run as a Distributed Data Base Management System. Is possible, throught PostgreSQL, to implement horizontal partition, this is, to fragment tables horizontally? For example, can I have a Data Base with 1 table, where it is horizontally fragmented a

[ADMIN] long term persistent tunnels

2004-08-19 Thread David Bear
Now that I have ssh tunneling working I am wondering what pitfalls away. Assume I have a server called db1 running the postgresql backend. Asume I have another server called web1 that will be connecting to db1 for data base operations. If I setup an ssh tunnel should I be aware of any problems w

Re: [ADMIN] tunneling through ssh

2004-08-19 Thread David Bear
On Wed, Aug 18, 2004 at 09:21:54PM -0400, Tom Lane wrote: > David Bear <[EMAIL PROTECTED]> writes: > > and on the ssh'd terminal tunnel session: > > > > $ channel 3: open failed: administratively prohibited: open failed > > --- > > Perhaps a firewalling problem? Look at your kernel p

Re: [HACKERS] [ADMIN] SRPM for 8.0.0 beta?

2004-08-19 Thread Joe Conway
Tom Lane wrote: Joe Conway <[EMAIL PROTECTED]> writes: On that, note that I specifically removed jdbc and tcl options from the spec file because the 8.0.0 release notes said they were removed from the distribution. I suppose at lease jdbc should be put back? It didn't seem right to include the 7

Re: [ADMIN] postgresql 8 - DNS server

2004-08-19 Thread Jim Seymour
"Van den bosch" <[EMAIL PROTECTED]> wrote: > > Unable to install postgreSQL 8 on a DNS-server, because during the > installation postgreSQL searches after \\servername\user, but the > servername differs > from the DNS name. > > Is there a workaround for this problem? Reconcile the NETBIOS and

Re: [ADMIN] postgresql 8 - DNS server

2004-08-19 Thread Magnus Hagander
This is with the MSI installer, right? Try using .\user instead of servername\user. This apparantly does not work on all OS versions, and I just can't remember which doesn't work, but it's worth a try. In general, try to fix your machine :) Having different netbios and DNS names *will* give you p

[ADMIN] postgresql 8 - DNS server

2004-08-19 Thread Van den bosch
Unable to install postgreSQL 8 on a DNS-server, because during the installation postgreSQL searches after \\servername\user, but the servername differs from the DNS name. Is there a workaround for this problem? Thanks, Guy ---(end of broadcast)--

Re: [ADMIN] Urgent --- Installation error on UltraSPARC-IIi processor version Postgres 7.3.2

2004-08-19 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 you're trying to run a intel binary on a sparc processor ?? That will never work!! It's like using gasoline in a diesel engine or using a hammer with a screw. Try compiling (or using a binary package) for the sparc platform. 7.3.2 is rather old, so y

[ADMIN] Urgent --- Installation error on UltraSPARC-IIi processor version Postgres 7.3.2

2004-08-19 Thread Somasekhar Bangalore
Hi All, I have installed postgres 7.3.2 on Linux Redhat 9 EE on intel processors. I am copying (tar) the installed directories and then I am installing the same on different flavors of linux like turbolinux ,Chinasoft on intel processors etc. The installation went just fine. No compiling of p