master
has reached its maximum memory limit... Before that it seems to
run quickly...
Regards
Andrew
Put both in,
the short for the managers who want to compare postgresql to
and the long for the techies
Andrew
On Sat, Jan 27, 2001 at 09:44:12PM -0500, Bruce Momjian wrote:
> Can I get some feedback from the group? Should a long or short version
> be used in the FAQ?
>
> >
Hi,
This is Andrew with ProV International.
I have
direct client requirement for the position of PostGre SQL
Database Administrator at San Diego, CA. For you reference given
below is the requirement. If you find this interesting and matching to
skills then please send across your
le for ANY user to install postgres under his own account, but
not recommended for security reasons.
Note that the ldconfig business above is Linux specific and not actually
necessary - you can use the LD_LIBRARY_PATH environment variable instea
ity to find
> function readline in psql.c, yet the routine readline.c has that
> routine. Beats me !!
SuSE Linux has caused the most problems of the various flavours.
The problems with curses are explained in the Linux-specific
FAQ.
Andrew
--
adline library to be up-to-date ?
Should be OK
Don't forget to re-run PostgreSQL configure once you've got this
stuff in place
Andrew
,.
--------
Dr. Andrew C.R. Martin University College
sql on the server with no problems. Should I be able to telnet
into linux on port 5432? Is there a way to make sure it is listening on this
port number?
Any help would be greatly appreciated.
Kind regards
Andrew Higgs
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
##
Any assistance would be greatly appreciated.
Kind regards
Andrew Higgs
anything.
Do some tests and find which query takes the longest. Find out if it is
actually postgresql that is using all the CPU time. Include details of what
versions of PostgreSQL and operating system you are using as well as
hardware configuration.
- Andrew
e password file. The obvious
> solution to the problem is to use a series of expects with perl on the
> remote system.
Please see the Postgres User's docs. There are SQL queries provided to
CREATE and DROP users, tables, and set a user's password.
- Andrew
#x27;d appreciate it.
ap
------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Carolina, Chapel Hill)
[EMAIL PROTECTED] - http://www.unc.edu/~aperrin
---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Verbose subject pretty much says it all. Depends on apache rotatelogs
for logging. Useful if you need to have a lot of backends or a lot of
different binaries, or both. Documented in inline comments.
- --
Andrew Hammond416-673-4138[EMAIL
EMC SAN
for storage and QLogix cards for fibre access.
Thanks,
Andrew
one table.
How long should the recovery process take?
Thanks,
Andrew
From: Anjan Dave
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 3:32
PM
To: Andrew Janian;
pgsql-admin@postgresql.org
Subject: RE: [ADMIN] startup
subprocess hangs
Probably some kind of a
It seems that I have made things
significantly worse. I am in the process of restoring from last night’s backup.
Then I should be able to get the data that I missed today back in.
Thanks for the help,
Andrew
From: Anjan Dave
[mailto:[EMAIL PROTECTED]
Sent: Friday
esponse is: ERROR: permission denied for relation lookatme
Obviously, I can write a script to iterate through all the tables, but
what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it
doesn't even grant basic access?
Any insight on the subject is welcome.
Th
esponse is: ERROR: permission denied for relation lookatme
Obviously, I can write a script to iterate through all the tables, but
what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it
doesn't even grant basic access?
Any insight on the subject is welcome.
T
and temporary tables, and that alone.
Whether you meant it or not, your initial comment came across as
patronizing.
Andrew Gold
Oliver Elphick wrote:
On Tue, 2005-08-16 at 16:07 -0700, Andrew Gold wrote:
Obviously, I can write a script to iterate through all the tables, but
what exactly d
t restriction on insertions.
SQL_ASCII does not represent a positive claim that the database knows
all the characters to be 7 bit characters. It represents instead the
complete absence of any encoding knowledge. Inserting high-bit
characters into a database using the SQL_ASCII character set may hav
without OIDs, which
will stave off your problem for a while. That'd probably even help
if the database mostly just grows, depending (of course) on where the
growth is.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technological problem. I
or that matter,
dissatisfactory) about Slony? I expect the developers would like to
know.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alex
Hi
I am trying to find details about open connections. I can see that there
are open connections through Tools | Server Status in pgAdmin III. How
can I find what the current and/or last SQL statement was that was run
in those open connections please?
Thanks for your help
Andrew
On Mon, Nov 14, 2005 at 06:19:16PM -0600, Kevin Grittner wrote:
> the moment aren't sure. The current machines are "transitional",
> and it may not be too late to set the permanent servers up with ECC
> memory. Is it something I should fight for?
Yes. Always.
A
--
A
take a _long_ time to complete (depending how big oyur
database is), and (as I noted) it will cause your application not to
work while it's going on.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
hers who've reported
it works (and it ought to, if the snapshots work as advertised --
just be sure you know what the snapshots actually are).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbo
ussed, I can't believe
you really need that much space.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
-
t it
_can_ use SSL, except that it doesn't have the ability to validate
via certs. So there'd be another potential use case for this. I
briefly toyed with trying to find someone to implement cert-based
authentication, but found I had other things more pressing (so the
TODO fell off the end
ot;psql dbname" and it hangs for a while. I'm still waiting. Any
> ideas?
What do your database logs say? I expect that you're in recovery
mode, but it's impossible to tell from this note.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn&#
say, it's very bad news,
but it shouldn't actually corrupt the database.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
---
ut I haven't done any real analysis of it.
The main thing is, "Don't do vacuum full."
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away from concreteness.
--George Orwell
---(end of broadcast)
On Fri, 2006-08-25 at 12:07 +0300, Achilleas Mantzios wrote:
> In the same sense java is prefered over PHP, since we dont intent to interfere
> with CMS code, but if some killer PHP app does the job, then it will be the
> one selected.
Take a look at eZpublish (http://ez.no). Killer PHP app, s
;do VACUUM
FULL". These aren't the same thing. My bet is what you need is
vacuumdb -a
You've probably missed a database you don't know is there.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
ll need the (postgresql) password for the account in
question to do this.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--B
On Wed, Sep 06, 2006 at 09:48:45AM -0700, Sriram Dandapani wrote:
> Is there a quick way(other than vacuum full) to re-init the transaction
> ids. (I can afford some downtime)
You don't need a vacuum full. You just need a bog-standard vacuum,
but you need it _on every database_.
A
you think will happen while
vacuum is running. If it's a lot, you could pass the fatal point (==
you lose data) before vacuum finishes. In most cases, it's probably
ok, but only you can decide how dangerous it would be for you to lose
data.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Th
On Thu, Sep 07, 2006 at 10:00:31AM -0400, Mr. Dan wrote:
> right. We think postgres is using UTC-5 for some reason. We don't have
Why do you think that?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
--Jan
runs only on 7.0 and 7.1 versions.
>
> I'm using pg 8.1.3 both sides, over linux.
>
> Do somebody has any tips?!?!
AFAIK, there isn't anything that does this today. There have been
various suggestions floated on how to emulate this with some
contortions using Slony, but
On Fri, Sep 29, 2006 at 10:24:01AM +0800, Chan Michael wrote:
> Hi Jim,
>
> Thanks for your info.
>
> Then in PostgreSQL 7.3 how can I use the WAL log to recover?
You can't. That's why it's a "new feature" in 8.0.
A
--
Andrew Sullivan | [EMAIL
| 0
You've set this up to rotate once every 10,080 minutes, no matter
what. If you've run into a file size limit, then you'll be out of
luck until the next file is opened, which should be on the same day
of the week the postmaster was last started. Just a guess.
A
--
An
a
major pain to restore in the event of such corruption. In addition,
your recovery will only be to the last dump. That's why I suggest
replicating, either with Slony or something else, as a belt that will
nicely complement the suspenders of your shared-disc failover.
A
--
Andrew Sullivan
u make, so that you don't have a garbage file to read.
As I said, I don't think that it's a bad idea to use this sort of
trick. I just think it's a poor single line of defence, because when
it fails, it fails hard.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future thi
eak at the same time, and have a
recovery plan for it. I submit that a recovery plan of "restore from
pg_dump" is usually not going to be enough if it was worth the cost
and hassle of setting up shared disk failover. YMMV, of course.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact
nd sleeps for a few seconds in between -- and
you shouldn't have this problem. But you'll need to VACUUM FULL or
dump and reload first.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Windows is a platform without soap, where rats run around
in open sewers.
--Daniel Eran
---
eployed systems. This happens to be true of commercial
offerings too (if not, you could buy the cheapest version of, say,
Oracle and get RAC in the bargain), but they _sell_ it to you as
though it were one big package. To the extent your managers don't
understand this, you're always
eSQL.
This is a very unfamiliar situation to most Oracle and some DB2
administrators, in my experience. The good ones, of course, have no
problem catching on; the bad ones never deserved the name DBA anyway
;-)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, "Wow, this software
t; TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Rit
ly) to your database without doing VACUUM? If you go to
single user mode and REINDEX that table you might find it helps.
Otherwise, I doubt they should be so large as a percentage, unless
you have an empty database with lots of columns with long names.
A
--
Andrew Sullivan
On Tue, Oct 14, 2003 at 11:32:03AM +0200, Daniel Rubio wrote:
> How I could solve this?
Upgrade to 7.3 and use the schema support to do it for you.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<
The program all builds for me.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
+1 416 646 3304 x110
e see the archives for the mailing list for erserver. They're
available at the erserver gborg site. In short, there is a bug in
the setup scripts, and you need to do some work by hand.
Instructions are in the archives.
A
--
Andrew Sullivan 204-4141 Yonge Street
unds like you're worrying about something that you need not
worry about. It is totally normal for your OS to "use up" memory
that is not otherwise used. Why have it if it's not going to be
used?
A
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada
ion between int4 and int8.
So finally, my question. Why is this behavior present? Is it actually a
feature that I don't know enough to appreciate?
Inquiring minds want to know...
Thanks,
Andrew Biagioni
---(end of broadcast)-
reproducable. I think Tom Lane is especially interested in
looking at cases like this; or he was last time I talked to him about
it.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
&
ea for fixing this data is wellcome. I will check the data
> inconsistent.
As I understand it, you need to zero out the file with dummy data in
order to get going again. You really need to plough the archives for
what to do, though. I've never had to do this.
A
--
Andrew Sullivan
know enough to appreciate?
Inquiring minds want to know...
Thanks,
Andrew Biagioni
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Wed, Oct 29, 2003 at 02:08:03PM -0500, Andrew Biagioni wrote:
>
> So finally, my question. Why is this behavior present? Is it actually
> a feature that I don't know enough to appreciate?
It's the side-effect of some other features in the system. If you
search o
> Its not. You should probably just get used to doing reply to all.
Or you can get a mail client that support "reply-to-list"
functionality. I seem to recall hearing rumours that pine will do
that. I know mutt does, because it's what I use.
A
Andrew Sullivan
numbers are different... I guess it did take. huh.
No, that probably just means that there is more variability to runs
than people like to imagine.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontar
ust long
enough to catch up any changes. Of course, you need twice the disk,
which is a pain, but it's certainly not impossible.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario C
.
BTW, there's a list just for erserver. You'll probably get better
help there. I suggest noodling around the erserver site, because the
archive has an explanation of this.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada
, "Probably
because of something you did."
~
My Website :http://www.angelfire.com/ia/japan/
BoomBox :http://www.b00mb0x.org
~~~~~
Andrew Rawnsley
President
The Ravensfield Digital Resou
On Tue, Nov 11, 2003 at 07:29:42PM +0100, Gaetano Mendola wrote:
>
> Seems that solaris is the worst choice for run Postgres.
>
> Am I completely wrong ?
Windows is worse ;-)
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada
r handling large numbers of processes. We get around that
by throwing hardware at the problem.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<[EMAIL PROTECTED]>
log connections, and then trace back to see
who connected with that pid. There was some discussion about
improving this for 7.4, but I don't know if any of that was done.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToront
f them can know about other programs' semaphore use. You
probably need more available semaphores from your kernel.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<[EMAIL PROTECTED]>
s in the
same order. They key to all this is understanding the implications
of lazy vacuum: tuples do not always stay in the same place on the
disk.
> If it is not the case, then you might need to sort each
> table dump before the diff.
Yes.
--
Andrew Sullivan
-quality?
I don't think so.
Jan Wieck has a proposal for a new replication system which will
offer a trick for producing point in time as a side benefit. We are
aiming to have that software in use sooner rather than later, but it
hasn't been written yet.
A
--
Andrew Sullivan
from a log.
No.
> (Is this to do with the recent Point-in-time recovery, and if so,
> will we have to wait for 7.5?)
Yes.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<[EMAIL PROTECTED]>
s. The bulk of
replication work takes place in the database. In extreme cases, there
_may_ be Java-based bottlenecks to be found, but that doesn't seem to
be the typical case.
There are some design problems in the erserver code that do cause some
bottlenecks -
see Andrew Sullivan's descriptio
with the tools that you can afford
without trying to jigger inappropriate technology to do something it
really can't
do. Trying to do something that the developers of a product say is not
possible, and selling it as HA, is not going to make you many friends
when
problems arise.
-
Our database ( (PostgreSQL) 7.3.5
) uses Unicode encoding:
egreek=# \l
List of databases
Name | Owner |
Encoding
-+--+--
egreek | andrew |
UNICODE
For some reason, If I try to use
an extended character (ASCII code
languages are at:
http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html
Andrew
Kent L. Nasveschuk wrote:
Hello,
I'm trying to write a trigger that upon inserting a value in a table
another table is decremented. Something that could be used in an
inventory system, for examp
an index scan if your
joining column's datatypes do not match
Thanks again,
Andrew
he very reason 7.3.4 was released.
Upgrade.
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
you'll
need to get some version of 7.3 running first.
A
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
!
If you're upgrading via RPM, why not just do a regular RPM
installation? Doesn't that work? (Extracting binaries from RPMs and
doing other such things sounds like the way to break something.)
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada
On Mon, Jan 05, 2004 at 07:35:16PM +0200, Tsirkin Evgeny wrote:
> On Mon, 5 Jan 2004 11:23:08 -0500, Andrew Sullivan
> <[EMAIL PROTECTED]> wrote:
>
> I want to keep my configs.Of course i can save my postgresql.conf
> (and other files that i changed and don't curren
of the instant that that query begins to run. Notice that two
successive SELECTs
can see different data, even though they are within a single
transaction, if other transactions commit changes during execution of
the first SELECT.
Andrew
V i s h a l Kashyap @ [Sai Hertz And Control
do I force postmaster to terminate active connections on other
databases?
Thanks
---(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
--------
as the versions for other systems.
_Similar_, perhaps. If IBM's jfs on AIX does what it appears to do
on Linux occasionally, I'm going to be one very unhappy camper.
A
--
Andrew Sullivan |
I remember when computers were frustrating because they *did* exactly what
you told them to. Th
Iain wrote:
Yes, you are right but it wasn't the case this time, I have run the
explain plenty of
times with same results. I think that the reason was that I made a simple
VACUUM,
after a VACUUM FULL ANALYZE (1h!!) things are ok
I
, they do hurt _quite substantially_ during
the checkpoint. If you need fast all the time, cranking that
interval too high will definitely hurt you.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
and that SCSI has been, historically anyway, better at
dealing with parallel loads. This is because of the historical
design goals of the two different systems. Glib remarks about
misinformation are easy to make, but don't really help anyone make
decisions.
A
--
Andrew Sullivan | [EMAIL P
th them, in fact, as its memory is limited by
the JVM limits.
The strategy is otherwise sound, though, and has even been used by,
uh, some of us.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
--Roger Brinner
--
It looks like you need to initdb.
> Aborted
You need the locale support offered by the Red Hat system. Seems you
need ISO 8859-15. My bet is either that Mandrake's locale doesn't
support that, you don't have the right libs, or the binary you've
installed wasn't co
build another 7.3.4 with result like building 7.4.1
Is this normal state of affairs?
Is "make install" safe with failed tests?
--
Andrew Kornilov
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ÐÐÐ 23 ÐÑÑ 2004 16:45, Tom Lane ÐÐ ÑÐÐÐ:
> "www.mg.te.ua" <[EMAIL PROTECTED]> writes:
> > mkdir
> > /usr/src/pg-7.4.1/src/test/regress/./tmp_check/install/usr/local/pgsql2/m
> >an/man7 gzip -d -c ./postgres.tar.gz | ( cd
> > /usr/src/pg-7.4.1/src/test/regress/./tmp_check/install/usr/local/pgsql
#x27;m not saying that master-slave systems are a bad idea, but you'd
better be aware of what you're exposing yourself to before
considering such hot-failover cases.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: su
itted transactions.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
---(end of broadcast)---
TIP 1: sub
able on the gborg site.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
--Roger Brinner
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ind a techno fix to the problem. (I still
like it that someone is spending some time on improving the crypto
stuff, though.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspu
these data, nobody is actually going to be able to prevent such an
attacker anyway. All you can do is limit your own liability in
exposing data; and that means collecting as little (not as much) as
you can, and then further attempting to protect the data you actually
do collect.
A
--
Andrew
than erserver. You may also
want to watch the PITR project, which appears to be aiming to get
into 7.5.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
su
IBM RS/6000 (P650), and it is one fast machine. It's
sort of unfair to compare it to UltraSPARC II machines, but I
certainly am impressed as compared to Sun's E4500.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde
s multiple PostgreSQL databases at the same time. Not separate schema,
> but in different postgresql server.
Doesn't seem like much security if you're going to break it by
putting a back door in. But there's a contrib module called dblink
that will likely help you.
A
--
Andrew S
NOT_ be "free"
> (again in their terms).
To be fair to the FSF, they have never claimed that the original BSD
license was not a free license. It just wasn't compatible with the
GPL, because of the advertising clause.
A
--
Andrew Sullivan | [EMAIL PROTEC
he
/usr/local/pgsql/ partition.
Thanks for any and all help!
Andrew Biagioni
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
Andrew Biagioni <[EMAIL PROTECTED]> writes:
On three different machines running the same PostgreSQL version (7.3.5)
on Linux and almost identical databases, I have been plagued by
occasional, unexplainable (to me) reboots of the computer.
Postgres can *not* cause a
sion/configuration (second machine); now we're out of
things to blame, except maybe unusually bad luck...
Thanks,
Andrew
Alex Satrapa wrote:
Andrew Biagioni wrote:
On three different machines running the same PostgreSQL version
(7.3.5) on Linux and almost identical databases,
scott.marlowe wrote:
On Tue, 30 Mar 2004, Andrew Biagioni wrote:
Alex,
the answer is "no" to all of these. We are a tiny start-up (2 guys, and
we do our own cleaning); ambient temperature varies significantly but
is not related to the failure, and one machine starts beeping whe
1 - 100 of 388 matches
Mail list logo
