Re: [ADMIN] tunneling through ssh

2004-08-18 Thread Jim Seymour
David Bear <[EMAIL PROTECTED]> wrote: > > I'm attempting to run pgsql through a tunnel. [snip] Through an ssh tunnel, using port-forwarding, I'm guessing? > > Am I missing something obvious? Can you "psql -p 5432" on the machine on which the server is running? Here's what I just did successf

Re: [ADMIN] tunneling through ssh

2004-08-18 Thread Tom Lane
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 packet filtering setup ... it's not uncommon for even local-loopback traf

Re: [ADMIN] tunneling through ssh

2004-08-18 Thread David Bear
On Wed, Aug 18, 2004 at 04:21:24PM -0700, Steve Crawford wrote: > On Wednesday 18 August 2004 4:13 pm, David Bear wrote: > > I'm attempting to run pgsql through a tunnel. I'm using the default > > pg_hba.conf file for now which has the relevant information: > > > > > > local all

Re: [ADMIN] tunneling through ssh

2004-08-18 Thread Steve Crawford
On Wednesday 18 August 2004 4:13 pm, David Bear wrote: > I'm attempting to run pgsql through a tunnel. I'm using the default > pg_hba.conf file for now which has the relevant information: > > > local all all > trust > hostall all 127.0.0.1 255.255.

[ADMIN] tunneling through ssh

2004-08-18 Thread David Bear
I'm attempting to run pgsql through a tunnel. I'm using the default pg_hba.conf file for now which has the relevant information: local all all trust hostall all 127.0.0.1 255.255.255.255 trust I assume this means that the back end wi

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

2004-08-18 Thread Andrew Dunstan
Joe Conway wrote: Tom Lane wrote: Well, *Marc* is working on including less stuff; the rest of us don't necessarily agree. In particular I've got to re-incorporate any major pieces that get removed from the core distribution, since people expect to find those in the RPM set. (In principle I supp

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

2004-08-18 Thread Tom Lane
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.4 jdbc

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

2004-08-18 Thread Joe Conway
Tom Lane wrote: Well, *Marc* is working on including less stuff; the rest of us don't necessarily agree. In particular I've got to re-incorporate any major pieces that get removed from the core distribution, since people expect to find those in the RPM set. (In principle I suppose they could be h

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

2004-08-18 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> In the PG case a >> single specfile currently aggregates the core server, jdbc, and >> pygresql ... and I'm getting pressure to include more stuff. > How does that compute, considering that everyone else appears to be > working on

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

2004-08-18 Thread Peter Eisentraut
Tom Lane wrote: > In the PG case a > single specfile currently aggregates the core server, jdbc, and > pygresql ... and I'm getting pressure to include more stuff. How does that compute, considering that everyone else appears to be working on including less stuff? > The init script is a differen

Re: [ADMIN] tracking db changes / comparing databases

2004-08-18 Thread Mitch Pirtle
[EMAIL PROTECTED] wrote: How do you share the data-definitions of your project(s) when they change (template1) ? Do you create all system-tables at pg_init runtime, and thus diff the C-source? The best approach IMHO is to use cvs and diff. For a more PHP-centric approach, you could look at ADO

Re: [ADMIN] tracking db changes / comparing databases

2004-08-18 Thread Michael Adler
On Wed, Aug 18, 2004 at 04:09:33PM +0200, [EMAIL PROTECTED] wrote: > How do you share the data-definitions of your project(s) when they > change (template1) ? Do you create all system-tables at pg_init > runtime, and thus diff the C-source? We track all DDL in CVS and manually create "patches" t

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

2004-08-18 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Isn't there a way to generate this automatically? Why isn't the .spec > file (and the debian directory, for that matter) part of the source > tree? Can't speak for Debian, but Red Hat at least would not use such a spec file anyway. RH's procedures inv

[ADMIN] tracking db changes / comparing databases

2004-08-18 Thread aplst
Hello Group, This question has been brought up on various mailing lists, but without any definite answers if I am correct. I am working on a system that can be used to rapidly create simple to medium complex applications in PHP. It basically features a forms-system, a reporting system, and databa

Re: [ADMIN] [GENERAL] High Availability - Performace Scalability

2004-08-18 Thread Mitch Pirtle
Dave Cramer wrote: Jerome, I'm curious what you expect out of clustering. High Availability, and Load Balancing seem possible, but Performance ? I would think there is a cost associated with clustering, that degrades performance. Anyways, to answer your question, there are a few tools that allow Hi

Re: [ADMIN] [GENERAL] High Availability - Performace Scalability -

2004-08-18 Thread Dave Cramer
Jerome, I'm curious what you expect out of clustering. High Availability, and Load Balancing seem possible, but Performance ? I would think there is a cost associated with clustering, that degrades performance. Anyways, to answer your question, there are a few tools that allow High Availability,

[ADMIN] High Availability - Performace Scalability - Dyanamic Load Balancing

2004-08-18 Thread JM
Hi All, I just came off an exibit and I was wondering if there ways to do clustering in postgres. I envy mySQL because there's a application for clustering it... EMIC networks has this marketing tagline: High Availability - Performace Scalability - Dyanami

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

2004-08-18 Thread Alvaro Herrera
On Tue, Aug 17, 2004 at 08:27:58PM -0700, Joe Conway wrote: > Tom Lane wrote: > >Joe Conway <[EMAIL PROTECTED]> writes: > > > >>Hopefully the third try is a charm ;-) > > > >>Version 3 is now available: fixes the init script. Previously > >>/etc/init.d/postgresql worked the first time used (i.e. w