-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> writes:
|
|>You can basically renice the process that is performing the query.
|
|
| However, that's unlikely to do anything very pleasant, since you'll have
| priority-inversion problems. "nice" ha
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> You can basically renice the process that is performing the query.
However, that's unlikely to do anything very pleasant, since you'll have
priority-inversion problems. "nice" has no idea when the process is
holding a lock that someone else wants ...
Chris Gamache wrote:
> What can be done to allow for smarter preemption? Could I do anything
at the OS
> level to throttle that particular postmaster's process? I'm running
(IMO) a
> balanced config, but there's always room for improvement. Its that
oddball
> query that comes around once every s
On Wed, 5 May 2004, Chris Gamache wrote:
> When I run an query (that I have identified as expensive, and non-critical), I
> would like to be able to take its priority down a few notches to allow the
> standard every-day tasks of the DB to run unhindered. As it stands, postmasters
> elbow each othe
When I run an query (that I have identified as expensive, and non-critical), I
would like to be able to take its priority down a few notches to allow the
standard every-day tasks of the DB to run unhindered. As it stands, postmasters
elbow each other out for processor time, and it seems like one ex
Richard Colman wrote:
> How would I set up a new user on PostgreSQL so that the new user is
> limited to reading a particular view, and can do nothing else.
A new user normally can't do anything. Just grant the privileges on the
view to him. You may also want to revoke all permissions on databa
>
> I am a novice in this area.
>
> How would I set up a new user on PostgreSQL so that the new user is limited
> to reading a particular view, and can do nothing else.
>
> Help greatly appreciated.
You will find these handy, no doubt...
http://www.postgresql.org/docs/7.4/static/tutorial.html
Ludek Finstrle <[EMAIL PROTECTED]> writes:
> bash-2.05$ /opt/software/postgresql/7.4.2/bin/initdb -D
> /data.sql/pgsql/7.4.X/standard -E UNICODE
> ...
> creating template1 database in /data.sql/pgsql/7.4.X/standard/base/1... ok
> initializing pg_shadow... FATAL: conversion between LATIN2 and UNIC
On Tue, 2004-05-04 at 13:37, Chris Hoover wrote:
> Does anyone know of a good tool to compare db schemas? I have over 200 db's
> that should all have identical schemas and have been asked to report on the
> differences.
>
http://pgdiff.sourceforge.net/
http://gborg.postgresql.org/project/pgdif
Richard Colman wrote:
> I am a novice in this area.
>
> How would I set up a new user on PostgreSQL so that the new user is
limited
> to reading a particular view, and can do nothing else.
Hi,
first of all create the user as no a super user, after use the
GRANT command
( http://www.postgresql.o
Does anyone know of a good way of implementing postgres real-time mirroring?
Whether it's a program that's already out there or whether it is something
that can be done by the DBA? I know there is one in contrib called dbmirror
but does it actually work well (it seems to also require pgperl)
Tha
Hello.
I compile pgsql 7.4.2 on Redhat 7.2 on dual AMD (32-bit arch) with:
./configure --prefix=/opt/software/postgresql/7.4.2 \
--enable-thread-safety --enable-integer-datetimes --enable-nls \
--with-pgport=5433 --with-perl --with-pam --with-openssl=/usr
make -j3
(I install bison-1875 bef
hi,
Chris Hoover wrote:
Does anyone know of a good tool to compare db schemas? I have over 200 db's
that should all have identical schemas and have been asked to report on the
differences.
if you looking for a program, check
http://ems-hitech.com/pgsqlutils/index.phtml#pgcomparer
but you can wri
I am a novice in this area.
How would I set up a new user on PostgreSQL so that the new user is limited
to reading a particular view, and can do nothing else.
Help greatly appreciated.
Richard Colman
Institute for Genomics and Bioinformatics
949-824-1816, 701-5330
[EMAIL PROTECTED]
---
That would seem to be the problem.
Thanks.
Kevin
- Original Message -
From: "Jim Seymour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 04, 2004 6:26 PM
Subject: Re: [ADMIN] initdb error
> "Kevin Schroeder" <[EMAIL PROTECTED]> wrote:
> >
> > Hello,
> > I'm trying
Shanmugasundaram Doraisamy <[EMAIL PROTECTED]> writes:
> + ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr
> --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc
> --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib
> --libexecdir=/usr/libexec --localstatedir=/var
Dear Group,
I am trying to install postgresql 7.3.6 on a
Redhat7.3 machine. I have downloaded the src.rpm from the site and
issued the rpm -bb postgresql.spec command and following is the output I
received. Any help would be verymuch appreciated. Thanking you,
Yours sinc
17 matches
Mail list logo
