Re: [GENERAL] installation guide

2005-10-14 Thread A. Kretschmer
am 13.10.2005, um 23:36:26 -0700 mailte srikanth potluri folgendes: > hi , > > can any one send me the setailed step by step installaiton guide of > postgre-sql on linux . Which distribution? You should use the distribution packet system. http://www.oryx.com/ams/postgresql.html Regards, And

Re: [GENERAL] installation guide

2005-10-14 Thread Richard Huxton
srikanth potluri wrote: hi , can any one send me the setailed step by step installaiton guide of postgre-sql on linux . i am a novice user of linux .. so i would be requiring very basic on information also ... i have been given assignment on installing postgresql on linux today You don't say

Re: [GENERAL] user privilages for executing pg_autovacuum?

2005-10-14 Thread Zlatko Matic
No, I didn't try ident authentication... It seems to me that security issues should be passd to client company's system administrator ? - Original Message - From: "Jim C. Nasby" <[EMAIL PROTECTED]> To: "Zlatko Matic" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Matthew T.

[GENERAL] Postgres logs to syslog LOCAL0

2005-10-14 Thread han . holl
Hi, I've noticed that, even though I specified LOCAL5 as syslog facility, postgres nevertheless logs _some_ events to LOCAL0. Log lines look like: Oct 14 08:55:02 pavenlo root palga [local] SELECT: [17-1] LOG: duration: \ 2953.658 ms statement: select rapnaam from udps where ((geboortedatum

[GENERAL] Using LISTEN/NOTIFY in C#.NET

2005-10-14 Thread Josephine de Castro
Hi guys!   Just the other day, I asked about the the equivalent of extended stored procedure in PostgreSQL.  A lot of people has been very helpful and i really appreciate all the suggestions and help that I got from this mailing list. :)   Anyway, i've done some serious google-ing and reading and i

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Andrew Sullivan
On Fri, Oct 14, 2005 at 07:48:00AM +0900, Tatsuo Ishii wrote: > > Why pgpool should bother? pgpool supposes every transaction should go > through pgpool. Your example sounds like someone logs into M2 and tries > to shut down it. But because there's no enforcement of "every transaction should go t

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Chris Travers
Andrew Sullivan wrote: On Thu, Oct 13, 2005 at 10:46:29AM -0500, Scott Marlowe wrote: choice in another. So, multi-master replication isn't likely to become a plug in module for postgresql any time soon. It's not even a thing, so it can't become a plug-in. I was referring specifi

[GENERAL] problem converting from 8.0.4 to 8.1beta3: character encoding

2005-10-14 Thread Rick Schumeyer
I have a database in pg 8.0.4 that is encoded as UNICODE.  Somehow, some “strange” characters made it in there.  Mostly, several instances of ‘ (apostrophe) are really some extended character.  They display in a text editor as \222 (or something similar).  I’m not sure how that happened, bu

Re: [GENERAL] more than one row returned by a subquery used as an

2005-10-14 Thread Alban Hertroys
CSN wrote: I'm trying to get this query to work: update sectors set companies =(select companies from industries where sector_id =sectors.id); Try these instead: update sectors set companies = industries.companies from industries where industries.sector_id =sectors.id; update industrie

Re: [GENERAL] Postgres logs to syslog LOCAL0

2005-10-14 Thread Bruce Momjian
I tested LOCAL5 here and got lines like: Oct 14 08:41:06 candle postgres[8668]: [1-1] LOG: duration: 1.210 ms statement: select 100; I don't see any SELECT: entry in there. In fact, SELECT: is coming from syslog, not from PostgreSQL. We only generate the stuff after the closi

Re: [GENERAL] Using LISTEN/NOTIFY in C#.NET

2005-10-14 Thread Douglas McNaught
Josephine de Castro <[EMAIL PROTECTED]> writes: > To make the long story short...my question is this..is it possible to run > the listener command in C# or will it only work in psql? There's no theoretical reason why not. You probably need to read the docs on whatever C# Postgres driver you're

[GENERAL] New sets of PostgreSQL RPMS are available for download : 7.3.10, 8.0.4, 8.1beta3

2005-10-14 Thread Devrim GUNDUZ
- PostgreSQL RPM Set Update 2005-10-14 Version(s): 7.3.10, 8.0.4, 8.1beta3 New set labels: 7.3.10-1PGDG, 8.0.4-2PGDG , 8.1beta3-1PGDG - --

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Alex Turner
  >multi-master.  It provides a certain amount of scaling, but nothing>I've seen or heard suggests that the license cost couldn't just as >easily and effectively be thrown at larger hardware for better>scaling.  The really big reason to use RAC is five-nines situations:>you're trying to make sure t

[GENERAL] Equivalent queries and the planner

2005-10-14 Thread John D. Burger
Hi - I have some questions about query equivalence. The first query below (actually a slightly more complicated one) took much longer to run than I expected (actually, I killed it after it ran all night). The second one took a few minutes. I believe these queries are exactly equivalent,

Re: [GENERAL] Using LISTEN/NOTIFY in C#.NET

2005-10-14 Thread Magnus Hagander
> > To make the long story short...my question is this..is it > possible to > > run the listener command in C# or will it only work in psql? > > There's no theoretical reason why not. You probably need to > read the docs on whatever C# Postgres driver you're using > (ADO, ODBC etc) and find o

Re: [GENERAL] PostgreSQL Gotchas

2005-10-14 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> and the lexer thinks that it should fold unquoted identifiers to upper >> case, then the catalog entries defining these names had better read >> PG_CLASS, RELPAGES, and MAX, not the lower-case names they contain >> tod

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Tatsuo Ishii
> But because there's no enforcement of "every transaction should go > through pgpool", it's not enough for the managers who are ultimately > responsible for deciding on system design. In the hypothetical case, > we're aiming at multimaster systems that are there for reliability, > not performance

Re: [GENERAL] Postgres logs to syslog LOCAL0

2005-10-14 Thread Tom Lane
Bruce Momjian writes: > I don't see any SELECT: entry in there. In fact, SELECT: is coming from > syslog, not from PostgreSQL. We only generate the stuff after the > closing ]. The SELECT: is probably coming from syslog_ident. I note the following comment in the Linux man page for syslog(3):

Re: [GENERAL] fine tuned database dump/reload?

2005-10-14 Thread Dan Armbrust
Jim C. Nasby wrote: Since no one else has mentioned it, there has been discussion this week on one of the lists (probably -general or -hackers) about expanding the capabilities of pg_dump. I've advocated for allowing a file that specifies what objects to dump and what kind of filtering to apply t

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Scott Marlowe
On Thu, 2005-10-13 at 17:48, Tatsuo Ishii wrote: > > On Thu, Oct 13, 2005 at 10:53:51AM -0700, Chris Travers wrote: > > > Now, what about PgPool as a multimaster sync replication solution? Sure > > > it is statement level But is there any reason why you cannot have > > > multiple PgPool ins

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Andrew Sullivan
On Fri, Oct 14, 2005 at 11:54:19PM +0900, Tatsuo Ishii wrote: > Enforcement? There would be plenty of ways to achieve that. For > example, you could set pg_hba.conf so that on ly the host where pgpool > is running on could connect to the host where postmaster is running > on. That just changes the

[GENERAL] PostgreSQL source inspection :)

2005-10-14 Thread Joshua D. Drake
Hello, Command Prompt has started a community project to allow for easier inspection of the PostgreSQL source. The project is no where near complete but this is what we have done: 1. Converted the entire PostgreSQL CVS repository to SVN. This includes all releases all the way back to the in

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Andrew Sullivan
On Fri, Oct 14, 2005 at 10:20:41AM -0500, Scott Marlowe wrote: > USers accessing machines behind the scenes is a VERY bad idea. It's not > a pgpool bug, is a user bug. :) The problem with this glib answer is that we are talking about systems where such a "user bug" can cost people millions of do

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Scott Marlowe
On Fri, 2005-10-14 at 10:48, Andrew Sullivan wrote: > On Fri, Oct 14, 2005 at 11:54:19PM +0900, Tatsuo Ishii wrote: > > Enforcement? There would be plenty of ways to achieve that. For > > example, you could set pg_hba.conf so that on ly the host where pgpool > > is running on could connect to the h

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Aly S.P Dharshi
Please allow me to wad into this discussion giving it a different view. LDAP is a form of a database, it has Multi-Master afaik it runs somewhat decently for two masters, can't we use a similar setup as say Fedora Directory Server or OpenLDAP's replication strategy and with some modification/impro

[GENERAL] Supplying password to pg_dump

2005-10-14 Thread Raymond O'Donnell
I'm trying to incorporate a backup/restore facility into a Delphi app, and I've run into trouble trying to get a password to pg_dump. I'm developing using PostgreSQL 8.0 on my WinXP Pro laptop. pg_dump is being executed by the Windows API function ShellExecuteEx(). I've tried putting a pgpass.c

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Tatsuo Ishii
> On Fri, 2005-10-14 at 10:48, Andrew Sullivan wrote: > > On Fri, Oct 14, 2005 at 11:54:19PM +0900, Tatsuo Ishii wrote: > > > Enforcement? There would be plenty of ways to achieve that. For > > > example, you could set pg_hba.conf so that on ly the host where pgpool > > > is running on could connec

Re: [GENERAL] PostgreSQL Gotchas

2005-10-14 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > Tom Lane <[EMAIL PROTECTED]> writes: > >> and the lexer thinks that it should fold unquoted identifiers to upper > >> case, then the catalog entries defining these names had better read > >> PG_CLASS, RELPAGES, and M

Re: [GENERAL] Postgres logs to syslog LOCAL0

2005-10-14 Thread han . holl
On Friday 14 October 2005 17:06, Tom Lane wrote: > > This is troubling since a reload of the config file could well move > things around. We should probably pass strdup(Syslog_ident) to openlog, > not just Syslog_ident. > I can confirm that we use reload quite a lot to switch between full statemen

Re: [GENERAL] PostgreSQL Gotchas

2005-10-14 Thread Jan Wieck
On 10/13/2005 2:40 PM, Tom Lane wrote: Chris Travers <[EMAIL PROTECTED]> writes: So basically, the problem is that any fix for case folding would touch a fair bit of code and possibly cause other problems. However, I haven't seen anyone worry about performance issues in such a fix, just that i

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Andrew Sullivan
On Sat, Oct 15, 2005 at 01:33:22AM +0900, Tatsuo Ishii wrote: > > BTW, the reason why I myself stick with pgpool is there's no > perfect or acceptable replication solution for PostgreSQL (please do > not talk about RAC or MySQL Cluster. I hate them:-). And that's part of why we're looking at it,

Re: [GENERAL] On "multi-master"

2005-10-14 Thread Andrew Sullivan
On Fri, Oct 14, 2005 at 11:16:36AM -0500, Scott Marlowe wrote: > You're users shouldn't be able to do that. If they can, you've set up > your system wrong. Only the DBA should have access to that machine. And DBAs aren't users? Oftentimes, a big goal is to protect against operator error. DBA

Re: [GENERAL] PostgreSQL Gotchas

2005-10-14 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > So two identifiers match if either is an unquoted identifier and they match > case insensitively. Or if both are quoted and they match case sensitively. Which part of "adhere to the standard" are you failing to get? The standard is 100% clear about what it

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Ron Mayer
Marc G. Fournier wrote: On Wed, 12 Oct 2005, Joshua D. Drake wrote: PostgreSQL doesn't suffer from that. Our only real, substantiated concern that I can see is the potential for the Software Patent crap. Stupid question here ... if Oracle came at us with "the Software Patent crap", Perso

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Joshua D. Drake
> Personally I think it's quite unlikely Oracle would try attacking > any F/OSS project on patent grounds. They've pretty much bet > the company on Linux (http://news.zdnet.com/2100-3513_22-5825433.html Linux isn't a competitor, PostgreSQL is. > My guess is that Oracle simply recognized that

Re: [GENERAL] PostgreSQL Gotchas

2005-10-14 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > So two identifiers match if either is an unquoted identifier and they match > > case insensitively. Or if both are quoted and they match case sensitively. > > Which part of "adhere to the standard" are you failing

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Scott Marlowe
On Fri, 2005-10-14 at 12:18, Ron Mayer wrote: > Marc G. Fournier wrote: > > On Wed, 12 Oct 2005, Joshua D. Drake wrote: > > > >> PostgreSQL doesn't suffer from that. Our only real, substantiated > >> concern that I can see is the potential for the Software Patent crap. > > > > > > Stupid questi

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > It would be great if Oracle paid to fork MySQL to a pure GPL product, > producing a new connection lib under LGPL, and hosting the whole thing > as a version of MySQL that ONLY uses innodb. > By forcing it to use one and only one table handler, they woul

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Ron Mayer
Joshua D. Drake wrote: [Ron Mayer wrote] ...Oracle...recognized...solid database engineers with a product with a growing customer base... ...made sense from both a recruiting and a business growth opportunity to acquire them. Oracle isn't interested in the 395.00 market. I think it's the lar

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Joshua D. Drake
> MySQL has a nice set of reference customers (MySQL AB's claims > include Google, US Census Bureau, Yahoo, Sabre, CERN, NASA, Associated > Press, Macys, Cox, Cable&Wireless, Nokia, Cisco, Sony, etc) - along > with a proven business structure (combination of product + marketing) You do know that

Re: [GENERAL] [pgsql-advocacy] Oracle buys Innobase

2005-10-14 Thread Andrew Sullivan
On Fri, Oct 14, 2005 at 01:02:00PM -0700, Ron Mayer wrote: > I'd suspect that any single postgresql-support company that had a > similar customer list would get offers from Oracle as well PostgreSQL support companies don't have the leverage that Oracle and MySQL do to get their clients to "come ou

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

2005-10-14 Thread Jeffrey Melloy
Joshua D. Drake wrote: Bruce Momjian wrote: Matthew Terenzio wrote: As much as I respect Marc and Postgresql.org, I can't see Oracle hiring him away as a "killer" threat to the community. People would set up camp somewhere else, like Command Prompt. It would hurt things for a while but t

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

2005-10-14 Thread Joshua D. Drake
> But what if they came in sideways and bought Command Prompt? Well then I would be sitting on a beach in New Zealend with an umbrella drink :) > (As an > example.) You could do a lot more to destroy PostgreSQL's market in the > business world by destroying the various support mechanisms.

[GENERAL] dynamic loading of .so

2005-10-14 Thread TJ O'Donnell
I have begun to use some static variables in my c-language functions to maintain state (3rd party licensing issues) during the course of a session (postgres process, spawned by postmaster). These are declared static outside the scope of any function. (is global the correct term anymore?) When I us

Re: [GENERAL] Oracle buys Innobase

2005-10-14 Thread CSN
There are some articles on eweek about this: Oracle Finds the Flaw in MySQL's Business Plan http://www.eweek.com/article2/0,1895,1869989,00.asp "This is what Oracle says in its release: "InnoDB's contractual relationship with MySQL comes up for renewal next year. Oracle fully expects to negotiate

Re: [GENERAL] dynamic loading of .so

2005-10-14 Thread Douglas McNaught
TJ O'Donnell <[EMAIL PROTECTED]> writes: > I have begun to use some static variables in my c-language > functions to maintain state (3rd party licensing issues) during > the course of a session (postgres process, spawned by postmaster). > These are declared static outside the scope of any function

[GENERAL] dynamic loading of .so

2005-10-14 Thread TJ O'Donnell
I have begun to use some static variables in my c-language functions to maintain state (3rd party licensing issues) during the course of a session (postgres process, spawned by postmaster). When I use dynamic loading of my .so, each session is independent, with its own static variables. Will the s