to investigate the failures very carefully. It is just recently that Red
Hat/Fedora Project has pulled through the -test subpackage into their
distribution; previously it was not built by them (disabled in the spec file)
due to space constraints and the potential for confusion.
--
Lamar Owen
to do for that release. However, I may appoint someone
for 7.4.x maintenance if the group thinks it is necessary. I already have a
volunteer to do so who is part of the group, so I'm not asking for
volunteers.
But I fully intend to do the 7.5 release. After that we'll see.
--
Lamar Owen
/var/spool/ftp/pub/binary/v7.4.1/redhat/redhat-7.3
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast)---
TIP 4: Don't 'kill -9
. If you run across
other dependencies you'll need to install those packages separately (for
instance, the python subpackage requires the 'mx' package from the main OS
install).
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
should work.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
.
My problem is that I can't find a binary or a source for tcl-devel for Red
Hat Linux 7.1.
The package doesn't exist in the 7.x series. All you need is the main tcl
package in 7.x, and the build7x macro in the spec file takes care of that.
--
Lamar Owen
Director of Information Technology
, the documentation seems to be bent on
building postgresql on the system.
See /usr/share/doc/postgresql-7.4.2/README.rpm-dist
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
that file.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
point me in the right direction, I'd
appreciate it.
Install the RHEL3 binary.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast
pages per second yu can get. A
load of 2.0, an average CPU of 60-100%, and 7 running processes is not bad at
all. It just means your server is working.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
try to rebuild the source RPM, if Slackware 9 has a functional RPM
building environment.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast
installation with the RPM's
(assuming PostgreSQL is not already installed):
rpm -i postgresql*7.3.4*.rpm
/sbin/service postgresql start
su - postgres
createdb ...
createuser ..
psql .
..
Hey, and I'm glad to see that you actually read the README.rpm-dist... :-)
--
Lamar Owen
Director
need to know
the specific version of the IBM SDK.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Friday 07 February 2003 09:13, Rajesh Kumar Mallah wrote:
installing from pgsql 7.3.2 tarball is not that difficult.
There are other things at work here; in any case, this does not answer his
question. He wants an answer to his RPM question.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
On Tuesday 04 February 2003 19:11, Sales wrote:
While installing Postgres-libs- 7.3.1 binaries on RedHat 8.0 , I get a
dependency problem. RPM reports dependency error postgresql-libs=7.2.2
required .
Which package did RPM say required it?
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
in postgresql.conf, which is in the same
directory as pg_hba.conf. You want to enable this setting, which is disabled
by default.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 6: Have you searched our list archives
to in the documentation.
Although you didn't mention rh-dump.sh, which is what the README.rpm-dist
documentation file specifically recommends instead of postgresql-dump.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get
both patch ( I added also the stop_immediate )
Many thanks.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
. Pretend you didn't see the 7.3-1PGDG
RPMset or if you did, and downloaded it, make that change to
/etc/rc.d/init.d/postgresql.
A 7.3-2PGDG RPMset is building nowwill upload as soon as it's done (I'm at
work; the T1 is cranked today)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
and exit, then 'rpmbuild -ba postgresql.spec', then install the rpms to
be found in /usr/src/redhat/RPMS/arch (i386 probably).
beta=1 defines both --enable-debug and --enable-cassert and allows the full
debugging, AFAIK. If it doesn't, then we need to look a little closer at
it...
--
Lamar
) which is postgres:postgres mode 700.
That's the standard place for PGDATA in Red Hat.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
significantly
better results in my experience. I welcome benchmark results to prove me
wrong :-).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
, as applicable).
There are way too many of those scripts that think routing stderr
to /dev/null is a good idea.
And until our stderr is rollable it will remain a good idea. Sorry. Syslog
is the best bet with our current non-rollable stderr.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
On Monday 06 May 2002 12:03 am, Lamar Owen wrote:
For debugging purposes, either editing /etc/rc.d/init.d/postgresql to
change the output redirect, or enabling syslog as documented in
/usr/share/doc/postgresql-7.2 (or 7.2.1, as applicable).
Urgh. Append 'README.rpm-dist' to that path
distribution,
See /usr/src/redhat/SOURCES/README.rpm-dist for instructions.
rpm --rebuild postgresql-7.2.1-2PGDG.src.rpm should work for most cases, if
you have all the packages installed that are required to build it.
What are you rebuilding on? (What version)
--
Lamar Owen
WGCR Internet Radio
1
. If not, I can try to help you, given a log of
the build (rpm -ba postgresql.spec 21 logfile.log).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--nodeps postgresql-7.2-1PGDG.src.rpm
Better is to install with RPM, as dependencies do actually have a use.
Use www.rpmfind.net to find the source RPM for the updated gettext RPM and
rebuild it first, then the main rebuild will go smoother.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
On Thursday 21 February 2002 11:16 pm, Antony Stace wrote:
Hi
Can someone please tell me what the PGDG stands for in
postgresql-7.2-1PGDG.rpm
Postgresql Global Development Group.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast
are the busiest two weeks of my work year.).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
includes PostgreSQL 7.1.3 as part of the base OS install.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
: How do I increase that without the need of a kernel
re-compile?
See the kernel sysctl docs for /proc/sys/kernel/shmmax
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
PostgreSQL box a number of times.
However, there was a problem with the version of readline used at one point
in time -- you might be running up against this buglet.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 1
a few hours ago
(while booted into windoze to run a network virus scan) check to see if my
PuTTY installation would work with my 7.2b3 RPM installation on RedHat 7.1.
History and backspace worked perfectly.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end
...
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
/data/postgresql.conf instead. The initscript WILL get
overwritten on the next RPM upgrade.
This is becoming a FAQ.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
, but there will only be one initscript
with an iterative loop. Use the GUC file -- it's there and it works.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org
-based Linux
distributions at least _tell_ you there's a problem.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
On Monday 20 August 2001 18:08, Chad R. Larson wrote:
On Mon, Aug 20, 2001 at 02:37:55PM -0400, Lamar Owen wrote:
And, YES, library versions under Linux distributions are as bad if
not worse than Windows' 'DLL Hell' is. Well, at least mostly.
RPM-based Linux distributions at least _tell_
-- much easier -- to rebuild from source via RPM than to build
and hand install from tarball, if you don't need too custom of a setup.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
-4PGDG.src.rpm
and pick up your binary RPMs from /usr/src/redhat/RPMS/i386.
Much simpler than a hand compile, at least on RedHat 7.1.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get off all lists at once
, the current PGDG set is quite close to what is in RawHide.
FWIW, RedHat 7.1 is currently the RPM reference platform, so the current
RPMset will work fine on RH 7.1.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 5
patch after configure).
The RPM is built with syslog support enabled -- you just need a line in
/etc/syslog.conf to receive the information. 7.0.x and 7.1.x use a different
means of configuring syslog, so you need to tell us which one you are using.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
.) Restart postmaster.
This should work, IIRC.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
for taking the time to report these things.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
the 7.1 initscript won't do a
kill -9.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Max Pyziur wrote:
Lamar Owen wrote:
Max Pyziur wrote:
The server starts up properly, however, I'm concerned that these error
messages nevertheless need to be rectified.
Corrected in the 7.1beta RPMs already, but thanks for the report.
Is there something to be concerned about and what
, however, I'm concerned that these error
messages nevertheless need to be rectified.
Corrected in the 7.1beta RPMs already, but thanks for the report.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
, the bandwidth to serve the pages of such a large number of
queries is going to be huge -- even America Online is only serving an
estimated 28 kilopages per second with their server farm.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
e --
which, if the recommendations in the upgrade docs (README.rpm) were
followed, there should be a copy of that file in the backup directory.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
as of yet. The pre-release
tarball is out there for testing, as announced by Marc on the Hackers
list Sunday (of course, you might not be subscribed to that list).
7.0.3 is a bugfix release to 7.0.2 only -- there are no new _features_
such as TOAST -- just bugfixes.
--
Lamar Owen
WGCR Internet Rad
, or directly e-mail [EMAIL PROTECTED] for more
details.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
.
No, you didn't mess up anything -- you just need to finish the job the
rpm upgrade started for you.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
/.s.PGSQL.5432) and retry.
/usr/local/pgsql/bin/postmaster: cannot create UNIX stream port
Is another postmaster running? (ps ax|grep postmaster)
Are the PostgreSQL RPM's that come with Mandrake 7 installed?
(rpm -qa|grep postgresql)
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
, and point those interested in perl interfacing to DBI and DBD::Pg,
but I am resigned to the likely fact that the Pg interface is likely to be
around for a very long time.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
required to compile the executables. Did I miss sth? Thanks again.
The executables are precompiled in the postgresql-test RPM. Simply cd
to /usr/lib/pgsql/test/regress, su to postgres, make sure postmaster is
running, and './regress.sh platform' Make is not required to run
regression in the RPM distribu
put e-mailed to you,
strip out the -q, and add verbose to the vacuum ("vacuum verbose
analyze").
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
Rich Shepard wrote:
What mode should PGDATA2/base or PGDATA have so I can create databases in
it?
700 is the right permissions -- make sure that the postgres user is the
owner of the PGDATA2.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
Rich Shepard wrote:
On Sat, 27 Nov 1999, Lamar Owen wrote:
700 is the right permissions -- make sure that the postgres user is the
owner of the PGDATA2.
Ah, ha! That must be the problem. The definition of PGLIB, PGDATA and
PGDATA2 are in *my* ~/.bash_profile. When I was logged
on location
purity and have a single RPM set than to be a purist and have a dozen
different 'pure' RPMs.
If it were reasonably feasible to do so, I'd make the RPM install much
more flexibly.
Hope that helps a little.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
capability, I'll go with FreeBSD. I am not religiously
tied to any OS -- that's the true benefit of multiple open-source OS's
(and RDBMS's!) -- I have a choice.
And when the day is ended, I still like my RedHat Linux server running
my RPM's of PostgreSQL 6.5.2. And it likes me.
--
Lamar Owen
WGC
output, segregate it, and pipe into syslog with the proper
options set.
The sidebar to this is "Which supported platforms don't have syslog?"
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
...).
Lamar Owen
WGCR Internet Radio
tgres
doesn't have sufficient permissions to that directory, or /sql/data
doesn't exist -- use mkdir to create it before running initdb. Make
sure that the user postgres (UID 500) both owns /sql/data, AND has rwx
rights to it.
Hope this helps.
Lamar Owen
WGCR Internet Radio
t upon why
it needs it. Again, mod-php in rpm form is ALREADY included in RedHat 6,
so you may not need to install PHP yourself.
Lamar Owen
WGCR Internet Radio
.
Lamar Owen
WGCR Internet Radio
of postgresql, you may want to read my
notes at http://www.ramifordistat.net/postgres .
Lamar Owen
WGCR Internet Radio
ct on http://www.ramifordistat.net/postgres
Lamar Owen
WGCR Internet Radio
maintenance was
done, from what version of what distro was the upgrade, to what version,
etc. The more details, the more likely you will be to get useful help.
HTH.
Lamar Owen
WGCR Internet Radio
, for example.
I use PUT with AOLserver, so allowing write access in necessary, YMMV.
Lamar OWen
WGCR Internet Radio
permission structures.
Again, I gave the caveat that my experience with php was extremely
limited, and that I was giving how I have things done with AOLserver,
which, IMO, is straightforward, simple, and secure.
With AOLserver's built-in tcl, no php is necessary.
Lamar Owen
WGCR Internet Radio
.
If this is an RPM-based upgrade, I have updated my RPM upgrade
instructions at http://www.ramifordistat.net/postgres/rpm_upgrade.html
to reflect the minor version upgrade possibilities.
Lamar Owen
WGCR Internet Radio
a bit ;-)). I AM looking for
feedback on the best ways to upgrade, however. Should rpm -U be
accomodated, or not even allowed? And many other questions that I will
post when I am a little more coherent
So: Caveat downloador...
Lamar Owen
WGCR Internet Radio
[EMAIL PROTECTED] wrote:
Though it'd be weird to run pg_dumpall from a perl script.
Probably better to keep that separate.
Thanks for the perl script -- gives me something to test the rpm perl
client installation... ;-)
Lamar Owen
WGCR Internet Radio
dump of hdc3 is done for full recovery -- but that is another article.
Lamar Owen
WGCR Internet Radio
to the incoming appropriate interface,
and you will need an explicit permit tcp any any below that to allow the
rest of your traffic through...
Lamar Owen
WGCR Internet Radio
To add a crontab entry like mine above, as user postgres execute
"crontab -e" -- you will be dropped into a vi session, from where you
can enter crontab entries, hit the ZZ in the usual way, and watch it
work.
Lamar Owen
WGCR Internet Radio
78 matches
Mail list logo