runlevel 5...
chkconfig postgresql on
is sufficient for most use.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Marko Kreen <[EMAIL PROTECTED]> writes:
> Another idea is stop storing hashes altogether
You can already avoid passwords by using kerberos authentication.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 2: you ca
r what you're using.
> - Ram: Not really sure here. Is there math somewhere for ram needs for
> pgsql? I imagine is has something to do with # connections, db size,
> etc.
"More is better. RAM is cheap. Avoid RAMBUS".
--
Trond Eivind Glomsrød
Red Hat, Inc.
dler concept and is the only relational
> database we know of built around this concept.
>
> => MySQL employs a table handler concept, which makes your code much less
> SQL compliant and makes MySQL harder to learn.
Do you have to use it, or is it something you can choose to take
advant
al sideeffect of fixing the "I changed the
postgres' users shell to tcsh and things don't work like they used to"
problem.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
"Hicnar" <[EMAIL PROTECTED]> writes:
> Hello,
>
> I was trying to install PostgreSQL ver 7.1.2, for RH 6.2, but some packages
> depend on ssl.so.0 and crypto.so.0 libraries.
>
> The question is: what packages contain those libs???
openssl.
--
v4.
Erratas (you have applied those, right? ;) also come in that format.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddre
t peeves), it needs to work.
> pg_dump issues, but the WAL truncation fix seems to be something that
> lots of people need.
Are those also in the 7.1-stable branch?
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 6: Have y
On Mon, 30 Jul 2001, Ben-Nes Michael wrote:
> The RPM support locale ?
The newest ones do.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes:
> Yes I did with locale + debug
It's known to work in the official RPMs. I suggest you take a look at
those, and at the output from configure on your own system.
--
Trond Eivind Glomsrød
Red Hat, Inc.
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes:
> The readline support don't work under Red Hat 7.1.
Yes, it does. I'm guessing you compiled postgresql yourself?
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)-
o.
The rpms of the Red Hat database are called rhdb, to avoid confusion.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
new version along side. In other words:
> >
> > /usr/lib/python1.5
> > /usr/lib/python2
>
> This is a bug in the RPM packages, which our maintainer has evidently
> neglected to fix.
Exactly what bug are you thinking of?
The current build process tries to detect your current v
t has the same underlying programs as Linux has for graphical display
(X, Gnome/KDE) - you might have a harder time getting accelerated 3D
graphics, other than that, the programs are similar.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)-
irewall as a "band-aid". ; )
ALmost all services are off as well. Openssh is on, sendmail is on
(but only accepts connects from the local machine), portmap is on and
that's about it.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)--
ling to spend (few things beat Sun Starfire :)
and the expertise you have or can build up.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
iliar with it.
> I'm sure we could go on, but this isn't a Linux list :)
Agreed. And of course, it isn't very interesting to discuss with
someone who is unfamiliar with the product.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
aturate our T1.
>
> Even though it may appear that your server is doing a lot, it's not facing
> the load of a highly scaled enterprise level e-commerce site, where RedHat
> just doesn't cut it.
That claim is bogus. Red Hat Linux is the number one linux by far in
enterprise depl
rupted? Won't test
> Running make install
> Make had some problems, maybe interrupted? Won't install
>
> cpan>
>
>
> How can I solve that problem?
Follow the rather explicit hints.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of bro
"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> On 25 Jun 2001, Trond Eivind Glomsrød wrote:
>
> > "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> >
> > > Always a first time for everything bad. Anyway, not wanting to b
e of the other open
> source projects RH supported was anything major they could make real
> money out of, at least not compared to what they can make out of the
> DB arena.
Uh? The database project is small FTTB (moneywise) compared to other
things like the kernel, gcc and glibc which are
c, fully-SQL-standard way.
>
> the project i'm doing this for is opensource and i need it to work in both
> postgresql and mysql. the above statement wouldn't work in mysql.
MySQL isn't close to SQL compatible.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
7.1 at
http://people.redhat.com/teg/
Feedback appreciated.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
gt; installed (short of doing a --nodeps I suppose)
>
> I tried to upgrade my openssl with the openssl-0.9.6-3.i386.rpm from
> redhat7.1 (using rpm -Uvh) but no luck as a lot of other rpm's were
> depending on libcrypt.so.0 and so on.
There is an openssl095a compatiblity pac
Here is a valid result:
are | 4
begynne | 6
zsh | 5
ære | 2
øve | 7
åre | 3
Here is an invalid result:
are | 4
begynne | 6
zsh | 5
åre | 3
ære | 2
øve | 7
The invalid result is what you'll get if you run postgresql
Lamar Owen <[EMAIL PROTECTED]> writes:
> On Monday 04 June 2001 10:56, Trond Eivind Glomsrød wrote:
> > Lamar Owen <[EMAIL PROTECTED]> writes:
> > > On Sunday 03 June 2001 13:05, Trond Eivind Glomsrød wrote:
> > > > "Tim Mickol" <[EMAIL PR
Lamar Owen <[EMAIL PROTECTED]> writes:
> On Sunday 03 June 2001 13:05, Trond Eivind Glomsrød wrote:
> > "Tim Mickol" <[EMAIL PROTECTED]> writes:
> > > any word on 7.1.2 in RPM or SRPM form?
>
> > An SRPM can be found at http://people.redhat.co
compare removing the RPM's:
rpm -e `rpm -qa |grep postgresql`
[...]
> #rpm --erase php-pgsql-3.0.15-2
That's not what you're doing for your manual install...
> rm -rf ~postgres/*
So postgres doesn't install it's binaries in /usr/local/bin, libraries
in /usr/local/lib
Lamar Owen <[EMAIL PROTECTED]> writes:
> I have considered making the default back to TCP/IP listening
I think that's a bad idea, for the "be secure by default" reason.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)-
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
>
> > "pg_ctl restart" seems to not work as documented in postgresql 7.1.2.
> >
> > bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast
> > waiting for po
ds - I'm not aware of any generic leaks.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
GH <[EMAIL PROTECTED]> writes:
> Somebody claimed that my post was uninformed...yet RedHat is all of Linux
> now?
No, of course not. Red Hat is more than Linux, Linux is more than our
version of it: Red Hat Linux.
--
Trond Eivind Glomsrød
Red Hat, Inc.
--
Michelle Murrain <[EMAIL PROTECTED]> writes:
> On Thursday 03 May 2001 11:58 am, Trond Eivind Glomsrød wrote:
> > GH <[EMAIL PROTECTED]> writes:
> > > On Wed, May 02, 2001 at 08:07:04PM +0100, some SMTP stream spewed forth:
> > > > I only have exper
Martín Marqués <[EMAIL PROTECTED]> writes:
> On Jue 03 May 2001 22:51, Trond Eivind Glomsrød wrote:
> > Bill Barnes <[EMAIL PROTECTED]> writes:
> > > Does anyone know of a package for 7.0.3 or 7.1 that
> > > will install in SuSE's latest release
Lamar Owen <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød wrote:
> > > Which case-sensitivity issue? The one about table and column names? Or
> > > a different one? (sitting confused in Pisgah Forest)
>
> > I remember there were some issues abo
e of the new unlimited size text
>
> As soon as I can get either pre-built 7.1 JDBC jars to ship as part of
> the RPM, or get time to install the pieces necessary to build JDBC on
> RH6.2, RH7.0, and RH7.1.
I'll create some jars and mail them to you.
--
Trond Eivind Glomsrød
If this is the case sensitivity
issue, that would count as a postgresql bug.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
n unresolved
> dependency on libreadline.so.3. I have a libreadline.so.4. Is that ok?
Install the readline2.2.1-2.2.1-2 rpm (which comes with Red Hat
Linux 7 - look on your CD or ftp mirror) for backwards compatibility.
--
Trond Eivind Glomsrød
Red Hat, Inc.
a new filesystem.
> several filesystems appear to support large files (but not ext2fs, and
> apparently not ext3fs)
On 2.2, it's VFS related. ext3/ext2 doesn't have such problems.
Red Hat Linux 7.0 includes a kernel (the "enterprise" one) with the
LFS patched included and test. It's also ready for 2.4
--
Trond Eivind Glomsrød
Red Hat, Inc.
e in some kernels
shipped with Red Hat Linux, and has been so for some time. Possibly
others.
--
Trond Eivind Glomsrød
Red Hat, Inc.
ograms aware of the fact you're
running on multiple machines and update all of the databases - and
handle the situation that one may be down, and needs to be updated
before going online again.
--
Trond Eivind Glomsrød
Red Hat, Inc.
"Adam Lang" <[EMAIL PROTECTED]> writes:
> But it don't help if you downloaded the OS. ;)
You can of course find it on the ftp site as well, in the RPMS directory.
--
Trond Eivind Glomsrød
Red Hat, Inc.
@
* (syslog=0 for stdio, syslog=1 for stdio+syslog, syslog=2 for syslog).
* For information see backend/utils/misc/trace.c (Massimo Dal Zotto).
*/
-/* #define USE_SYSLOG */
+#define USE_SYSLOG
--
Trond Eivind Glomsrød
Red Hat, Inc.
imes rather weird) schemes), but I'm also interested in upgrading
the database component.
--
Trond Eivind Glomsrød
Red Hat, Inc.
don't know that postgresql is running. It probably isn't.
2) You don't know that you have the diskspace to do that.
--
Trond Eivind Glomsrød
Red Hat, Inc.
database. If you do this before and after upgrading,
you'll hopefully have the same data in the database.
--
Trond Eivind Glomsrød
Red Hat, Inc.
t stay
> as part of the distribution because of upgrading issues.
I've never said or indicated that.
That said, I dislike the current no-upgrade policy.
--
Trond Eivind Glomsrød
Red Hat, Inc.
retty straightforward Web Serving bundle.
So is Postgresql, PHP and Apache - no MySQL necesarry.
--
Trond Eivind Glomsrød
Red Hat, Inc.
them manually afterwards, select "everything" or choose to
manually select packages.
Of course, we may switch the defaults in the future if we think MySQL
is a better database in terms of upgradability, reliability, features
and performance but there are no such plans right now.
--
Trond Eivind Glomsrød
Red Hat, Inc.
will mean that Postgres has stopped improving.
Not necesarrily - one could either design a on disk format with room
for expansion or create migration tools to add new fields.
--
Trond Eivind Glomsrød
Red Hat, Inc.
> > database when upgrading the OS, like in most Linux distributions.
>
> why not? pg_dump;pkrm old;pkadd new;load ... no?
Because the system is down during this upgrade - the database isn't
running. Also, automated dump might lead to data loss if space becomes
an issue.
--
Trond Eivind Glomsrød
Red Hat, Inc.
r a release ...
Will there be a clean upgrade path this time, or
yet another dump-initdb-restore procedure?
Unclean upgrades are one of major disadvantages of postgresql FTTB,
IMHO.
--
Trond Eivind Glomsrød
Red Hat, Inc.
gt; > yet another dump-initdb-restore procedure?
>
> IMHO, upgrading a database server is like upgrading an operating system
> ... you scheduale downtime, back it all up and upgrade ...
The problem is, this doesn't play that well with upgrading the
database when upgrading the OS, like in most Linux distributions.
--
Trond Eivind Glomsrød
Red Hat, Inc.
When I
> try to install the rpm (rpm -i postgresql-7_0_2-2_i386.rpm)
You obviously can't install postgresql binary RPMs for Intel on an
Alpha - get the SRPM and do a rpm --rebuild of it.
--
Trond Eivind Glomsrød
Red Hat, Inc.
ompetitor to Microsoft's SQL server than
Microsoft Access. It's a server, and doesn't have the equivalent GUI
functionality of Access.
--
Trond Eivind Glomsrød
Red Hat, Inc.
[EMAIL PROTECTED] (Jan Wieck) writes:
> Trond Eivind=?iso-8859-1?q?_Glomsr=F8d?= wrote:
> > [EMAIL PROTECTED] (Jan Wieck) writes:
> >
> > > Trond Eivind Glomsrød wrote:
> > > > [EMAIL PROTECTED] (Jan Wieck) writes:
> > > >
> > > > >
[EMAIL PROTECTED] (Jan Wieck) writes:
> Trond Eivind Glomsrød wrote:
> > [EMAIL PROTECTED] (Jan Wieck) writes:
> >
> > > Trond Eivind Glomsrød wrote:
> > > > Mike Mascari <[EMAIL PROTECTED]> writes:
> > > >
> > > > > This is
57 matches
Mail list logo
