On Tue, 27 Jan 2004, Net Llama! wrote:
> Greetings,
> I've been tasked with maintaining a postgresql-7.3.4 database that has a
> J2EE app on the front end.
>
> In the pgsql log I see thousands upon thousands of entries like these:
> WARNING: COMMIT: no transaction in progress
I believe this is
Well in fact we're currently using SQL server 2000, which doesn't
support object oriented technology; however, I was researching the
possibility of migrating to a database that provides the features I
mentioned, as, although not 100% crucial to the application, they fit
pretty well with the nature
I'll try to look into that. I'm doing the processing on 7.3.4, so I'll have
to find some spare resources for 7.4.1. Maybe it was a fluke or something.
I did an "overwrite" make install into the same directory as the original
7.3.4 (new data directory though), so maybe I shouldn't have done that?
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> No offense intended but I doubt the estimator will get things right all the
> time (esp if my built-in Murphy Field Intensifier happens to be on).
Doesn't mean we shouldn't strive to improve it. The present code for
estimating number of groups is new in
On Tuesday 27 January 2004 03:51 pm, Alvaro Herrera wrote:
> On Tue, Jan 27, 2004 at 03:08:23PM -1000, Jerome Lyles wrote:
> > > I don't think so --- the postmaster will actively refuse to start if
> > > you try to run it as root. Better take another look at exactly what's
> > > happening.
> >
> >
"William Harazim" <[EMAIL PROTECTED]> writes:
> Ahh, the password || username format of the stored password was the problem.
> Incidentally, for anyone else not having the md5() function (is that new to 7.5dev?)
> I was able to accomplish the same thing using
>'md5' || encode( digest(passwor
Jerome Lyles <[EMAIL PROTECTED]> writes:
> On Tuesday 27 January 2004 06:41 am, Tom Lane wrote:
>> I don't think so --- the postmaster will actively refuse to start if you
>> try to run it as root. Better take another look at exactly what's
>> happening.
> Running the postmaster as root:
> [EMAI
Brendan Jurd <[EMAIL PROTECTED]> writes:
> I think the idea of the update default has interesting possbilities.
> Perhaps what is needed is two classes of defaults.
> 1. "implicit default" -- any updates to a tuple either not specifying a
> value for the target column at all, or specifying DE
A file system mirror (provided its the same type of system) will be
much easier. Just shut down postgres
on the test machine and rsync away. Dump and restore on something that
size will take a looong time.
On Jan 27, 2004, at 7:36 PM, Colm De Barra wrote:
Hi
I've built up 30 gig database on
-BEGIN PGP SIGNED MESSAGE-
(BHash: SHA1
(B
(B
(BIf the test and productive machine are the same type (i.e. intel) and the
(Bpostgresql version is the same then I would try to do a filesystem copy.
(BJust make sure both machines have the postmaster shut down and then copy over
(Bthe
Tom Lane wrote:
A different tack that might be interesting to think about is to invent
a notion of an "update default" for a column, analogous to the existing
"insert default". The normal behavior is that the "update default" is
the old value, but if you could specify some computable expression
On Tue, Jan 27, 2004 at 03:08:23PM -1000, Jerome Lyles wrote:
> > I don't think so --- the postmaster will actively refuse to start if you
> > try to run it as root. Better take another look at exactly what's
> > happening.
>
> Well two out of three isn't bad:-). I'll let you be the judge:
> Ru
Ahh, the password || username format of the stored password was the problem.
Incidentally, for anyone else not having the md5() function (is that new to 7.5dev?) I
was able to accomplish the same thing using
'md5' || encode( digest(password || username, 'md5'), 'hex' )
Thanks!
-Origi
On Tuesday 27 January 2004 06:41 am, Tom Lane wrote:
> Jerome Lyles <[EMAIL PROTECTED]> writes:
> > I'm trying to build a database. But none of the users I try to use
> > works.
>
> I think you are confused about the distinction between Postgres users
> and Unix users. The set of user names known
"William Harazim" <[EMAIL PROTECTED]> writes:
> Is there a way, having a user entered username and password, to select a si=
> ngle row from pg_shadow which is using md5 password encryption?
I think what you need to know is that the stored passwd field is formed
thus:
'md5' || md5(passwor
(B
(B
(BHi
(BI've built up 30 gig database on a performance test
(Bmachine which
(Bnow needs to be transferred over onto the
(Bproduction hardware
(Bwhich will be going live.
(BThe documentation suggests using pg_dump or a file
(Bsystem level backup
(B - does anyone have any experien
On Tuesday 27 January 2004 12:05 am, Richard Huxton wrote:
>
> OK - it's complaining it can't connect to template1. This is the database
> that contains all the default tables/types/functions etc. that will appear
> in your new database.
>
> First thing to check is that PG is running. Does it show
Is there a way, having a user entered username and password, to select a single row
from pg_shadow which is using md5 password encryption?
I'm currently authenticating web users (.asp page) with our own user table that uses
crypt() to store passwords. I'd like to remove our 'redundant' user tab
http://www.palomine.net/qmail/selectiverelay.html
This document tells you how to do it in qmail.
MM
- - - -
OpenBSD -
Sending Script kiddies to /dev/null since 1995.
"Marc G. Fournier" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/27/2004 03:20 PM
To: Gary
On Tue, 27 Jan 2004, Gary Stimson wrote:
> Hi Marc
>
> I have a Celeron 1.3 at ev1servers.net in texas that just sits doing remote
> backup, mail and DNS. Plenty of spare bandwidth and CPU. It runs qmail. Any
> use?
Sure, but I don't know how to setup qmail for it ... anyone?
Marc G. Fourni
Appendum to this ... to do mail relaying for this, there is nothing
specially that has to be installed on your server, it is just a simple
configuration change depending on your MTA ...
For instance, with sendmail, you add a line similar to:
200.46.204.71 RELAY
to your access file
With postfix
On Tue, Jan 27, 2004 at 15:28:02 -0400,
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>
> Right now, we have the following TLDs covered:
>
> /\.(jp)$/
> /\.(fr|uk|de|pl|ad|se|gr|be|ch|dk|es|fi|gi|ie|it|lu|nl|no|pt|tr|at)$/
> /\.(com|net|org|ca|edu|biz|us|mil|ws|info)$/
You should probably th
I'm trying to build a database. But none of the users I try to use works.
I as normal user doesn't work:
:~> createdb mydb
createdb: could not connect to database template1: FATAL: user "adriel" does
not exist
I as postgresql user doesn't work:
:~> createdb mydb
createdb: could not connect to
On Tue, Jan 27, 2004 at 03:42:09PM +0800, Lincoln Yeoh wrote:
> Hi,
>
> I recently upgraded to postgresql 7.4 and I am having a problem with
> postmaster using lots of memory for a query (keeps growing even up to
> 400MB+ till I stop postgresql ). I don't recall this ever happening with
> 7.3 w
Hello,
I've accidently created a whole bunch of tables and sequences in template1.
I didn't actually want the information in template1 but with the slip of a key my script piped all the commands into it and now all the info is there, doh!.
Problem is now that I try to create the DB I wan
Hi,
I recently upgraded to postgresql 7.4 and I am having a problem with
postmaster using lots of memory for a query (keeps growing even up to
400MB+ till I stop postgresql ). I don't recall this ever happening with
7.3 with the exact same query but on different data (just as much data tho,
or
26 matches
Mail list logo
