A unix box or a mainframe that needs rebooting is generally considered
broken.
On Thu, 2005-02-17 at 17:11, Andrew Hall wrote:
> We do the maintenance reboot (and other various log cleanups etc) as part of
> our normal maintenance practice. We don't really 'need' to do this, however
> we've trad
We do the maintenance reboot (and other various log cleanups etc) as part of
our normal maintenance practice. We don't really 'need' to do this, however
we've traditionally found that operating systems perform better with an
occassional reboot (cleanup fragmented memory etc.).
- Original Me
Lonni J Friedman <[EMAIL PROTECTED]> writes:
> On Thu, 17 Feb 2005 15:41:11 -0500, Geoffrey <[EMAIL PROTECTED]> wrote:
>> Not what's going on there, I'd appreciate hearing anyone who might have
>> some insights...
> Its called up2date.
or even more specifically, day-zero security errata. The CD
"Sailer, Denis (YBUSA-CDR)" <[EMAIL PROTECTED]> writes:
> The following errors also showed up. So my question is why does the
> failure of CREATE INDEX cause all my connections to be terminated and
> the database to go into recovery mode? Sounds kind of drastic.
Not having any xlog space is fata
Lonni J Friedman wrote:
On Thu, 17 Feb 2005 15:41:11 -0500, Geoffrey <[EMAIL PROTECTED]> wrote:
FYI, Seems there might be some confusion on the part of Red Hat.
Checking the 4.0 channel on the Red Hat Network for the version of
Postgresql that comes on 4.0 I see:
postgresql-7.4.7-2.RHEL4.1
Whereas
On Thu, 17 Feb 2005 15:41:11 -0500, Geoffrey <[EMAIL PROTECTED]> wrote:
> FYI, Seems there might be some confusion on the part of Red Hat.
> Checking the 4.0 channel on the Red Hat Network for the version of
> Postgresql that comes on 4.0 I see:
>
> postgresql-7.4.7-2.RHEL4.1
>
> Whereas, on the
FYI, Seems there might be some confusion on the part of Red Hat.
Checking the 4.0 channel on the Red Hat Network for the version of
Postgresql that comes on 4.0 I see:
postgresql-7.4.7-2.RHEL4.1
Whereas, on the iso I downloaded I find:
postgresql-7.4.6-1.RHEL4.2
Not what's going on there, I'd a
I was trying to create an index on a 37,000,000 row table
and received the following error. Evidently I don’t have enough
space in my pg_xlog directory to handle this as a single transaction. The
file system for pg_xlog is allocated 2GB. The following output is
from a psql session direc
> hi, is it possible to change the current user's password from a
> function/stored procedure , I mean, is there a system function/stored
> procedure to do it? like the dbo.sp_password found in adaptive server
> anywhere.
>
CREATE OR REPLACE FUNCTION public.alter_password(name, name)
RETURNS "
I found an distutils rpm and installed I am still getting the same
message. I tried rebuilding the rpm with
rpmbuild --rebuild postgres-7.4.6-2PGDG.src.rpm --define 'python 0'
I then complains about kerberos.
Is there any precompiled RPMS for 7.4.6 64 bit anywhere.
Thanks
Lonni J Friedman wrote:
On Thu, Feb 17, 2005 at 02:30:33PM -0400, Hugo Takada wrote:
>
> hi, is it possible to change the current user's password from a
> function/stored procedure , I mean, is there a system function/stored
> procedure to do it? like the dbo.sp_password found in adaptive server
> anywhere.
See the docu
On Thu, Feb 17, 2005 at 07:31:42PM +0100, Martijn van Oosterhout wrote:
> On Thu, Feb 17, 2005 at 11:03:58AM -0700, Michael Fuhr wrote:
> >
> > In experiments I've defined a domain's CHECK expression to call a
> > function that makes queries. It worked in simple tests; I don't
> > know if it'll wo
This looks like your problem:
http://groups-beta.google.com/group/comp.databases.postgresql.hackers/browse_thread/thread/3f0008119f1568e6/796dbcf05a53518a?q=%22+checking+how+to+link+an+embedded+Python+Application%22&_done=%2Fgroups%3Fas_epq%3D+checking+how+to+link+an+embedded+Python+Application%26s
If you have command line support for PHP it is fairly easy to
write a program that would use "pg_escape_string" to condition
the data. You could even use "pg_copy_to" to send the data
to the db as well.
On Mon, 2005-14-02 at 22:30 -0500, Bruce Momjian wrote:
> I did some research on this and it
hi, is it possible to change the current user's password from a
function/stored procedure , I mean, is there a system function/stored
procedure to do it? like the dbo.sp_password found in adaptive server
anywhere.
thanks in advance
Hugo
---(end of broadcast)-
On Thu, Feb 17, 2005 at 11:03:58AM -0700, Michael Fuhr wrote:
> On Thu, Feb 17, 2005 at 04:37:43PM +0100, Wolfgang Drotschmann wrote:
>
> > "...CHECK expressions cannot contain subqueries nor refer to
> > variables other than VALUE."
>
> In experiments I've defined a domain's CHECK expression to
On Thu, Feb 17, 2005 at 10:14:15AM -0200, alexandre::aldeia digital wrote:
>
> Can I kill a postgres user process inside a function (SP)?
Functions written in C, PL/Perl, PL/Tcl, etc., can use whatever
facilities those languages provide, such as sending signals to
processes. Whether that's a goo
This is being compiled on Redhat ES 3.0 X86_64 Update 4 Release. I
looked in the config.log the only thing I could find was this messages
configure:4681: checking how to link an embedded Python Application
configure:4685: result: no
configure:4687: error: Python Makefile not found
Thanks
Jo
On Thu, Feb 17, 2005 at 04:37:43PM +0100, Wolfgang Drotschmann wrote:
> "...CHECK expressions cannot contain subqueries nor refer to
> variables other than VALUE."
In experiments I've defined a domain's CHECK expression to call a
function that makes queries. It worked in simple tests; I don't
k
On Thu, 2005-02-17 at 12:36 -0500, John Zubac wrote:
> Hi Everyone
>
> I am just asking about any suggestions on an advanced postgresql book.
> This would be for our current SQL programmer and for myself. We do not
> need a beginer book since with are both not beginers in the RDMS DB
> world. We a
Title: Suggestions on a good Postgresql 7.4 or 8.0 book
Hi Everyone
I am just asking about any suggestions on an advanced postgresql book. This would be for our current SQL programmer and for myself. We do not need a beginer book since with are both not beginers in the RDMS DB world. We are
On Thu, 17 Feb 2005 11:58:47 -0500, John Allgood <[EMAIL PROTECTED]> wrote:
> Hello All
>
> I am trying to build 7.4.6 src rpms and when I issue the command
> rpmbuild --rebuild postgres-7.4.6-2PGDG.src.rpm. I get the following error
>
> configure: error: Python Makefile not found.
> error: B
Hello All
I am trying to build 7.4.6 src rpms and when I issue the command
rpmbuild --rebuild postgres-7.4.6-2PGDG.src.rpm. I get the following error
configure: error: Python Makefile not found.
error: Bad exit status from /var/tmp/rpm-tmp.81768
Anyone got any ideas.
This is a AMD Opteron Syst
Hallo all,
in part VI (the reference), the online manual for 8.0.1 states for command
CREATE DOMAIN for parameter
CHECK (expression)
that currently
"...CHECK expressions cannot contain subqueries nor refer to
variables other than VALUE."
So, is this an item for the TODO list? I can't find i
"Andrew Hall" <[EMAIL PROTECTED]> writes:
> I can't be sure. We have an automated maintenance process that reboots all
> our customers machines every 10 days at 2am.
Why? Sounds like a decision made by someone who is used to Windows.
I've never seen any variant of Unix that needed that.
On Thu, Feb 17, 2005 at 07:40:25PM +1100, Andrew Hall wrote:
>
> We have an automated maintenance process that reboots all our
> customers machines every 10 days at 2am.
What's the purpose of doing this? If it's necessary then the reboots
aren't really fixing anything. Is whatever problem that
Hi,
pgpool(http://pgfoundry.org/projects/pgpool/) now has CVS repository
on pgfoundry.org. To grab the latest source via anonymous CVS:
1) login (first time only)
cvs -d:pserver:[EMAIL PROTECTED]:/cvsroot/pgpool login
you will be asked password. just type return.
2) to get pgpool entire source
I just went from compiling PostgreSQL 8.0.1 and all was fine, but when I
launched
initdb -D /opt/postgresql-8.0.1/lib/data/ --encoding=LATIN1 --locale=es_ES
all that I got was
FATAL: could not open file "$libdir/ascii_and_mic"
I dirtly changed $libdir for /opt/postgresql-8.0.1/lib
in /opt/postgre
Hi,
Can I kill a postgres user process inside a function (SP)?
Sometimes, the java program that our company uses stay in "idle in
transaction" and every day, I need to import a text data to some tables
in DB.
This import make a TRUNCATE in this tables and I need to kill the
remaining process bef
HI ...
I have been using PG for a large project at my work (soon in
production), and I use PG and a lot for FK/RI checks. This works nice
when using one or two threads (cuncurrent connections), but more than
this, and I start getting deadlocks in my FK triggers.
After this, I have been reading
Hi, Pitesh,
[EMAIL PROTECTED] schrieb:
> You can't simply restore a dump to upgrade postgis
> for two reasons:
>
> 1) postgis library name might have changed (this is the case).
> 2) postgis procedural language function might be changed
> and you'd get the old ones.
>
> You
I have a postgresql function at the bottom , when i run at EMS POSTGRESQL
debug mode with F8 step by step. Its work great but when i use with play
button it returns null what is the different about debug mode and run mode.
BEST REGARDS.
CREATE OR REPLACE FUNCTION "public"."allocatedamount" (v
I was wondering if this problem had ever shown up on a machine that
HADN'T lost power abrubtly or not. IFF the only machines that
experience corruption have lost power beforehand sometime, then I would
look towards either the drives, controller or file system or somewhere
in there.
I can't be sure
Do you happen to have the same type disks in all these systems? That could
point to a disk cache "problem" (f.e. the disks lying about having written
data from the cache to disk).
Or do you use the same disk parameters on all these machines? Have you
tried using the disks w/o write caching and/
I know this is a silly question, but when you write 'We do nothing with
any indexes' do you mean indeces are never, _never_ touched (I mean
explicitly, as in drop/create index), i.e. they are created at schema
creation time and then left alone? Just to make sure...
Hi and thanks for your feedback,
35 matches
Mail list logo