ERROR: CLUSTER cannot be executed from a function or multi-command
string
I got this error from a script which tried:
psql -U postgres db1 -c 'cluster ; analyze'
In the docs there's no word that it's not possible, and I wonder why
this is not allowed. Anybody knows? It's stupid, as I want to c
On Dienstag 28 April 2009 dx k9 wrote:
> with SLES 9
I'd believe your start/stop scripts are not original, but anyway with
SLES 9, you should contact Novell support. That's what you pay for ;-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 3
Thank you guys for the answers.
On Tue, Apr 28, 2009 at 6:06 PM, Joshua D. Drake wrote:
>
> >
> > Ops team want to install postgres as (usr/local/bin) using RPM, and
> > want to keep the data directory under (/var/lib/data/pgsql) and they
> > say that we cannot have two versions at the same time
>
> Ops team want to install postgres as (usr/local/bin) using RPM, and
> want to keep the data directory under (/var/lib/data/pgsql) and they
> say that we cannot have two versions at the same time using RPM.
> They say that red hat standard is to install all binaries of the
> database under /us
On Tue, Apr 28, 2009 at 6:08 PM, John R Pierce wrote:
> I for one use the PGDG yum rpm repository, and install the 8.3 on top of the
> default rhel/centos 4 or 5 binaries. the repository includes a
> compatibility library which satisfies RPM dependencies on the original RHEL
> versions of the li
On Tue, Apr 28, 2009 at 6:00 PM, DM wrote:
> Hi All,
> What is the best way to Install postgres database?
> We have installed (2) versions of the postgres on th server using source
> code (compiling and building) (/usr/local/pgsql/8.3.3/ and
> /usr/local/pgsql/8.3.6/) and our data directory is (/m
DM wrote:
Hi All,
What is the best way to Install postgres database?
We have installed (2) versions of the postgres on th server using
source code (compiling and building) (/usr/local/pgsql/8.3.3/ and
/usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/)
Our database size is m
Hi All,
What is the best way to Install postgres database?
We have installed (2) versions of the postgres on th server using source
code (compiling and building) (/usr/local/pgsql/8.3.3/ and
/usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/)
Our database size is more than 100GB.
I found the origin of my problem very easily. The fact is that I didn't know
that one could see the tables' relationships within Navicat. When I checked my
faculty table it turned out that there were 5 relationships between the two
fields. The problem was, obviously, that adding a new foreign ke
Just as a follow up.. The same thing happened again after just going into yast
and viewing the run level services. After I exit'd yast, ALL instances of
postgres went down on the server.
Hi,
I wanted to report a new way to shut down a postgres instance. I
was troubleshooting a PAM-war
Paul Rogers schrieb:
If so then how did you handle permissions, errors, connection pooling?
Hey there!
I'm currently working on an .NET application with user- and
privilege-management via database.
Privileges and access to frontend modules (in the application), tables,
functions etc. (in d
Στις Tuesday 28 April 2009 15:27:58 ο/η Paul Rogers έγραψε:
> If so then how did you handle permissions, errors, connection pooling?
>
In jboss for instance you could do that using
org.jboss.security.auth.spi.DatabaseServerLoginModule
in conf/login-config.xml
One issue might be the quering of p
If so then how did you handle permissions, errors, connection pooling?
Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
mess
Hi,I am working on a data warehousing project, our system is handling
huge amount of live data.
We get data in form of events.
Frequency of events goes up to 1000 events/second. average frequency is 200
events/second.
We are using libpg to connect pg-server and insert each event into database
t
Hello,
regarding the logging settings I've some questions.
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html
log_rotation_age
Are log files automatically rotated at midnight per default as it seems?
Wouldn't truncate_on_rotation cause information loss otherwise? If the
15 matches
Mail list logo
