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
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
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.
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
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
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
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
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
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
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
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
-
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
-
--
>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
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,
> > 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
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
> 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
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):
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
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
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
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
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
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
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
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
> 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
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
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
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
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,
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
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
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
> 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
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
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
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
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
> 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
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
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
> 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.
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
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
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
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
47 matches
Mail list logo