ntil later, Geoffrey
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Any functional use? (other than a tough
learning experience?)
--
Until later, Geoffrey
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ld love to hear from anyone who is doing
something similar or knows it will not work. So we won't bleed too much..
--
Until later, Geoffrey
---(end of broadcast)---
TIP 6: explain analyze is your friend
subscribe
--
Until later, Geoffrey
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Geoffrey wrote:
subscribe
Sorry, not enough coffee yet
--
Until later, Geoffrey
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Postgresql, not the kernel. Thus, it doesn't make sense to me that the
max_files_per_process setting is too high. I would think we need to
increase it so that Postgresql will stop generating these errors.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a l
Alvaro Herrera wrote:
Geoffrey wrote:
Alvaro Herrera wrote:
John Allgood wrote:
Hey Tom
I assume that if it is the kernel running out of descriptors that I
would get the messages in dmesg. This message only appears in the log
file for that database.
Yeah, the point is that you have the
Bradley Kieser wrote:
Hmm, not entirely true. You may well only see the error in the process
itself.
You're telling me that the kernel could be running out of file
descriptors and I wouldn't see a message regarding this in the kernel
logs? I don't believe that is possible
Alvaro Herrera wrote:
Geoffrey wrote:
Okay, I'm just not getting it. Postgres complains that it is out of
file descriptors. The kernel is not complaining about any such issues.
So I should lower the max_files_per_process
value and this will rid us of the &#
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
I work with the original poster and wanted to make sure the problem here
is clear. The 'out of file descriptors' message is coming from
Postgresql, not the kernel. Thus, it doesn't make sense to me that the
max_file
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Alvaro Herrera wrote:
Yes. Which is kinda weird, because Postgres actually tests the number
when it starts, so that if you set the number too high, it will decrease
it according to what the kernel allows.
Maybe the test is newer th
they
will be going with the Access solution. I've got concerns regarding
this based on research I've done that seems to indicate that Access,
when used in a multi-user solution is easily corrupted. Does anyone
have any knowledge/experience with such issues?
--
Until later, Geoffrey [
Michelle Murrain wrote:
On Tue, 2003-11-04 at 12:46, Geoffrey wrote:
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
us
only one person could access a spreadsheet at one time and no more
copying files across their network.
--
Until later, Geoffrey [EMAIL PROTECTED]
Building secure systems inspite of Microsoft
---(end of broadcast)---
TIP 2: you can get off a
Michelle Murrain wrote:
On Tue, 2003-11-04 at 21:39, Geoffrey wrote:
Okay, so how do you approach this? Access front end will talk to
postgresql? Pointers to any docs would be appreciated.
Access front end talks with Postgresql via ODBC. Can be a little flakey
at times, but it works well in
ftware Ingenier neither a DB Admin.
I understand what you are saying, but I would submit that convenience is
never a substitute for data integrity.
--
Until later, Geoffrey [EMAIL PROTECTED]
Building secure systems inspite of Microsoft
---(end of broadcast)--
ue and suggest
whether the use of PostgreSQL for commercial purpose is no license
charge or not
I would suggest that if you work for a commercial company, you should
have your corporate attorneys review the licenses for your company's sake.
--
Until later, Geoffrey Regis
own if the temperature runs too high. Is
the machine properly cooled? Does it have plenty of space so as to have
the proper air flow? What's the processor type? (we all know amd
processors run hotter).
--
Until later, Geoffrey Registered Linux User #108567
Building secure syst
s.
--
Until later, Geoffrey Registered Linux User #108567
Building secure systems in spite of Microsoft
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
offers all this functionality.
--
Until later, Geoffrey Registered Linux User #108567
Building secure systems in spite of Microsoft
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ce he was the idiot who
couldn't undo what he had done.. You've got more patience for stupidity
then I do.
--
Until later, Geoffrey Registered Linux User #108567
Building secure systems in spite of Microsoft
---(e
Raquel Vieira wrote:
I asked to unsubscribe me from this list but I'm still receiving mails.
That is likely because it is your responsibility to unsubscribe from the
list as was indicated by the information provided to you when you
subscribed.
--
Until later, Geo
ght have, you have to tell cron
to reread the crontab file for it to process your addition. Your better
solution is to use the tools designed for editing crontab, such as
'crontab -e.' If you use this tool, crontab will automagically reread
the file.
--
Until later,
Lawrence C wrote:
Hi Tim,
How do I setup cronjob for user "postgres" then in
scripts? that what i mean
thanks :)
log in or su to postgres and 'crontab -e' to edit the postgres crontab.
OR
as root 'crontab -u postgres -e'
--
Until later, Geoffrey
s would be greatly appreciated.
--
Until later, Geoffrey Registered Linux User #108567
AT&T Certified UNIX System Programmer - 1995
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
ct line caused an immediate delete
as I just new it was a variation of a scam..
Useful subject lines would be appreciated in the future.
--
Until later, Geoffrey Registered Linux User #108567
AT&T Certified UNIX System Programmer - 1995
;s no /etc/init.d/postgresql file (even not
/etc/init.d/rh-posgtresql file, or anything simmilar).
Look for 'rhdb' If that fails, the following will more than likely
locate it:
cd /etc/rc.d; find . -type f -print |xargs grep -l postmaster
--
Until later, Geoffrey
---
off the top of my head..
--
Until later, Geoffrey
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
has always had? Now you're looking
at this package having a problem where as the problem was created by the
installation/upgrade of another package.
The sys admin should be involved to some extent in all software
installations.
--
Until later, Geoffrey
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
A workaround is symlinking /usr/lib/kerberos/* to /usr.
We are aware of that and 7.4.7 will ship with that change.
Hmm, guess I need to patch my SPEC file.
--
Until later, Geoffrey
---(end of broadcast
te, there's another reference to kerberos in the
spec file:
%{!?kerbdir:%define kerbdir "/usr/kerberos"}
As noted, I'm not a spec file expert and don't have the time to research
this at this point, but maybe it will give you a lead as to resolving
your issues.
--
Until
ingle user,
unmount your new /usr/local so you can remove the old stuff that was in
the old /usr/local partition/directory in order to recover that space.
Others may shoot this down because of issues with Postgresql I'm not
aware of, but I do this all the time to move stuff around or create new
I've checked the mirrors and although there is a directory for x86 64
bit rpms, it's empty. Are there plans to build these any time soon?
Anyone point me to the latest srpms for 7.4.?
Thanks.
--
Until later, Geoffrey
---(end of broadcast)---
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Feb 2005, Geoffrey wrote:
I've checked the mirrors and although there is a directory for x86 64
bit rpms, it's empty. Are there plans to build these any time soon?
Yep there is(was), but we are not su
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Feb 2005, Geoffrey wrote:
Anyone point me to the latest srpms for 7.4.?
http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/
Can I build 64 bit from these, or do I need specific 64 bit srpms
I will try to catch up
with the RPM building tomorrow!
Not a problem. Absolutely no need for an apology. Thanks so much for
all the effort.
--
Until later, Geoffrey
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
.net/PostgreSQL/.
Devrim: can you put them on the official FTP site?
Again my apologies for letting everyone wait so long
Sander.
Thanks again, I am humbled by your efforts...
--
Until later, Geoffrey
---(end of broadcast)---
TIP 6: Have you searched ou
onsible were punished.
So, where'd you hide the body?
--
Until later, Geoffrey
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
sounds like a fun thing to try :)
--
Until later, Geoffrey
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
You need to build all software that runs with PostgreSQL.
Can you justify this statement with experiences?
--
Until later, Geoffrey
---(end of broadcast)---
TIP 4: Don't &#x
postgresql-15.log since
then and up until now it is still writing to the same file , its been
over a week and 6 hours now.
Long shot, has the machine date/time changed? Assuming that's what the
process is keying off of.
If not, I'll climb back into my lurk...
--
Until later
We had a vacuum fail recently with the following error:
invalid page header in block 846 of relation "move_pkey"
Anyone have an idea what could cause this problem and what we need to do
to resolve it?
Running on Red Hat Enterprise 3, postgres 7.4.13
--
Until later, Geoffrey
Geoffrey wrote:
We had a vacuum fail recently with the following error:
invalid page header in block 846 of relation "move_pkey"
Anyone have an idea what could cause this problem and what we need to do
to resolve it?
Running on Red Hat Enterprise 3, postgres 7.4.13
Regarding
Scott Marlowe wrote:
On Fri, 2007-01-05 at 16:19, Geoffrey wrote:
Geoffrey wrote:
We had a vacuum fail recently with the following error:
invalid page header in block 846 of relation "move_pkey"
Anyone have an idea what could cause this problem and what we need to do
to
else that I could tune in the OS. My max_connections=35
and shared buffers=8192 for my largest database.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
as been running.
I can think of a couple of ways...
ps aux|grep postmaster
ls -l postmaster.pid
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(e
amewar-starting question?
As a nudist, I think I have to answer, "About every 9 weeks, it would
seem".
Jeese! You could have warned us to shield our eyes!
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Li
Based on how often it crashes?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)---
TIP 9: In versions below
ion of postgresql, can anyone point to anything that might
cause this to happen?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)-
hen. Heck, even ln worked ( in a manner of
speaking ) back then.
There's also Uwin from AT&T:
http://www.research.att.com/sw/tools/uwin
list of available commands and man pages:
http://www.research.att.com/~gsf/man/man1/
--
Until later, Geoffrey
Those who would give up essential Libe
should only 'vacuum
full' when you run into space issues.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 07 Jan 2008 10:53:11 -0500
Geoffrey <[EMAIL PROTECTED]> wrote:
So, I'm wondering if anyone can point me to more specific information
as to when, if ever, you should 'vacuum full?'
1. If you ov
pgserver-A pg-dbname
I don't think this is really a postgres question, but the fact you're on
a UNIX type of OS, you should have no problem doing this. uncompress
will simply open the file separately for each shell session.
--
Until later, Geoffrey
Those who would give up esse
server-A pg-dbname
I'm assuming the above line should have been:
uncompress -c pgdump-filename.Z | psql -h pgserver-B pg-dbname
^
^
--
Until later, Geoffrey
Those who would give up es
to the
tape.
What would the correct syntax be for that - I can't figure out how to make
tar accept stdin:
I don't think it can.
Coming in the middle of this thread, so slap me if I'm off base here.
tar will accept standard in as:
tar -cf -
the '-f -' says take in
want to make sure I understand your post.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Joshua D. Drake wrote:
I would avoid 8.3 without extensive testing. 8.2.6 is likely a better
shot a minimizing one off incompatibilities.
We are in a very similar situation in that we are looking to migrate
from 7.4 to 8.3. So
ible or accessible, but they still occupy disk space. This might
amount to a considerable amount of wasted disk space if the failure
happened well into a large copy operation. You might wish to invoke
VACUUM to recover the wasted space.
What are we missing?
--
Until later, Geoffrey
Those who
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
We are trying to test our process for upgrading our database from 7.4.19
to 8.3.1. We are following the instructions for dumping the 7.4.19
database from:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
ie:
/usr/loca
Shane Ambler wrote:
Geoffrey wrote:
We are trying to test our process for upgrading our database from
7.4.19 to 8.3.1. We are following the instructions for dumping the
7.4.19 database from:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
ie:
/usr/local/pg83/bin
I recently was bitten by having two servers where the database encoding
was different. When I do an 'initdb' how does it determine the 'default'
encoding?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve
I ran into a problem with the wrong encoding on our database and I want
to figure out if it's because the environment is different on this box,
or if it was caused by the upgrade from 7.4 to 8.3
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
tempor
ignorance, as I don't run any 64bit kernels, but is that a 64
bit kernel he's listed?
2.6.9-42.ELsmp
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-adm
connected shared data silo.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
Scott Marlowe wrote:
On Fri, Aug 21, 2009 at 11:42 AM, Geoffrey wrote:
We have a two node cluster and we are planning on adding a third.
P.s. what do you mean by two node cluster? What software are you
using to do this?
Red Hat clustering suite. The machines are accessing the data on a
Can anyone point me to any stats on how well postgresql performs on
various OS's? I'm particularily interested in BSD variations and Linux.
--
Until later: Geoffrey [EMAIL PROTECTED]
The latest, most widespread virus? Microsoft end user agreement.
Thin
ould find info on exporting
>>excel data into postgresql, or how to do it. Thanks!
>
>
> Try to save your data from excel in csv format and then use a _COPY_ to
> load it to a _previously created table_._
>
> _Good Luck!
>
> Geza Gemes_
> _
>
--
Until later
I have been trying to install the DBD-Pg driver for
the DBI interface.
I am using Red Hat 6-2 and
postgresql-7.0.2-2.i386.rpm et al.
Postgresql is installed and running
smoothly.
The perl interface is connecting and
happy.
perl-DBI-1.13-1.i386.rpm is installed and seems to
be O.K.
The
So, what is the problem? Is this the right path to migration? Would
installing the network a be a better solution?
Wondering,
Geoffrey
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Postgresql, "dump"ing from the XP machine and migrating was a snap.
Thank you again,
Geoffrey
On Fri, 18 Feb 2005 11:42:15 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> Geoffrey Ducharme wrote:
> > Hi everyone, I'm new to PostgreSQL administration. I hope the
amewar-starting question?
As a nudist, I think I have to answer, "About every 9 weeks, it would
seem".
Jeese! You could have forwarned us to shut our eyes!
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Li
StumbleUpon
Discover your web
Popular Websites
http://www.stumbleupon.com/redirect.php?t=j&u=18579366&d=http%3A%2F%2Fbuzz.stumbleupon.com%2F&l=6&c=mfruyoq65tmdoa15
People Online Now
http://www.stumbleupon.com/redirect.php?t=j&u=18579366&d=http%3A%2F%2Fwww.stumbleupon.com%2Fpeople%2F&l=6&c=mfruyo
new machine, it did not retain the timezone setting.
Is there a way to retain this information from the original database
when reloading?
Thanks.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people unde
Steve Crawford wrote:
On 11/09/2011 05:10 AM, Geoffrey Myers wrote:
We are moving a number of databases to new hardware. Some of these
machines have the timezone set in the database differently then the
actual location of the machine as they are access from a different
timezone. We were
Steve Crawford wrote:
On 11/09/2011 11:41 AM, Geoffrey Myers wrote:
Geoffrey Myers wrote:
Tom Lane wrote:
Steve Crawford writes:
On 11/09/2011 05:10 AM, Geoffrey Myers wrote:
Is there a way to retain this information from the original
database when reloading?
Time-zone setting is an
e? Am I doing something wrong? Is
there a step I'm missing? A google search revealed somebody with a similar
problem upgrading from 6.5.x a year ago, but there didn't seem to be any
resolution to it.
TIA,
---
Geoffrey Wossum
Software Engineer
Long Range Systems - http://
-- Forwarded Message --
Subject: Re: [ADMIN] Problems upgrading from 7.1.3
Date: Wednesday 05 February 2003 01:39 pm
From: Geoffrey Wossum <[EMAIL PROTECTED]>
To: "Bjoern Metzdorf" <[EMAIL PROTECTED]>
On Wednesday 05 February 2003 11:36 am, you wrote:
&g
_dumpall to dump the 7.1.3's database as
recommended in the admin manual, but had the same result. Maybe I forgot to
mention that in my original email. There were a lot of combinations I had to
mention ^_^
Thanks,
---
Geoffrey Wossum
Software Engineer
Long Range Systems - http://www.pager
w, why did this all work fine if I added "-D" to pg_dump/pg_dumpall?
Shouldn't that have failed for the same reason?
Thanks,
---
Geoffrey Wossum
Software Engineer
Long Range Systems - http://www.pager.net
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
79 matches
Mail list logo
