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 ...
so , friends , please help me out
Tom Lane [EMAIL PROTECTED] writes:
If you write, say,
select max(relpages) from pg_class;
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
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,
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
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. O'Connor
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
Hi guys!
Just the other day,I askedabout the the equivalentof extended stored procedure in PostgreSQL.A lot of people has been very helpful and i really appreciateall the suggestions and help that I got from this mailing list.:)
Anyway, i've done some serious google-ing and reading and i came
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
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
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). Im not
sure how that happened, but they
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
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
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
-
snip
multi-master.It provides a certain amount of scaling, but nothingI've seen or heard suggests that the license cost couldn't just as
easily and effectively be thrown at larger hardware for betterscaling.The really big reason to use RAC is five-nines situations:you're trying to make sure that
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
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 out how
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
today.
Well
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 pgman@candle.pha.pa.us 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
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
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 instances
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
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
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 host
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
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
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
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 MAX, not the
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 statement
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 it
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. DBAs
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,
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 the
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 to get? The
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 question here ... if
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 would
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
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, CableWireless, Nokia, Cisco, Sony, etc) - along
with a proven business structure (combination of product + marketing)
You do know that many
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 out
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
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
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
49 matches
Mail list logo