lost your
WAL.
> Are there any postgres specific recovery procedures and /or documentation on how
> to prevent such situations?
The recovery in this case is pg_resetxlog. As for prevention, it
depends on what happened. Any ideas?
A
--
Andrew Sullivan 204-41
> postgres[32066]: [288403] DEBUG: statistics collector process (pid
> 14965) exited with exit code 1
You need to be able to connect on 127.0.0.1, or the stats collector
can't start. Is that it?
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
section of the manual for details.
> and... do my questions sound stupid? ;-)
No, but you might want to have a look at the manuals: there's a lot
of info there.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario
n why it worked? There is no survid column
in participants, so I would have expected it to generate an error on the
sub-select, not match all rows!
Thanks for any help.
------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor o
often
ap
------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Wed, 30 Oct 2002, Tom Lane wrote:
> Andrew Perrin <[EMAIL PROTECTED]> writes
nclear to me right now.) To find out the
timetable to make eRServer work with 7.3, you should contact
PostgreSQL, Inc.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMA
hings that changed. But there
is _certainly_ a window in which you could get an inconsistent
snapshot, and then your backup would be completely useless. A high
volume of write operations is a good way to cause the problem.
A
--
Andrew Sullivan 204
On Mon, Nov 04, 2002 at 10:06:59AM -0500, Eric Comeau wrote:
> Andrew
>
> 1) Would you use erServer in a non-DBA environment?
I'm not sure what a non-DBA environment is -- _someone_ has to be
running the database. But if your question is, "Does someone need to
hold its hand
for Postgres). Don't
take my word for it, though, as I'm not a Postgres hacker.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
On Tue, Nov 12, 2002 at 03:55:55PM -0500, Tom Lane wrote:
>
> Hmm, maybe a portability problem in the pg_regress script ... but I
> thought we'd already checked 7.3 on Solaris. Andrew, can you reproduce
> this problem?
It worked for me in the last beta; but someone reported th
p a different awk (there are two on Solaris), because I was
also working on another problem during the same period. (I can try
out this theory today, if I'm lucky enough to get a minute or two.)
Bad dba! Test in a clean environment! I apologise.
A
--
Andrew Su
On Wed, Nov 13, 2002 at 07:56:38AM -0500, Andrew Sullivan wrote:
> I'll bet it had to do with a funky path I had, though; probably I
> picked up a different awk (there are two on Solaris), because I was
> also working on another problem during the same period. (I can try
For the
cuumed in that
billion transaction period, but it is nevertheless probable that some
of your tables will not need to be vacuumed as often as others. For
efficiency's sake, therefore, you may want to vacuum different tables
at different times.
A
--
Andrew Sullivan
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
As far as I can tell (yes, I tested thoroughly) if I create a normal
deadlock situation as follows, th
Stephan Szabo wrote:
On Mon, 13 Jan 2003, Andrew Biagioni wrote:
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
ables.
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Thu, 16 Jan 2003, Tim Lynch wrote:
> First, sorry for the OT, flame me off-list!
>
> I'm a sysadmin b
Hey, thanks - nice to learn something.
ap
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Fri, 17 Jan 2003
ime to poke at
your LD_LIBRARY_PATH, and make sure that you actually have readline
installed.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]>
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
As far as I can tell (yes, I tested thoroughly) if I create a normal
deadlock situation as follows,
nds accept a "-U " parameter that
lets you specify what user you want to run the command as (postgreSQL user,
that is, not linux user) ).
Bottom line: the simple solution is to su (to root), then su to postgres, then
do what you need to do - create real users for the DB, possibly on
Be careful with your pg_hba.conf entries (read the comments in the file itself,
they are lengthy but useful). What you configured (below) will allow anyone
to connect to your database from any machine without validation, as long
as their IP address has the first two blocks equal to your machin
t we want to replicate
> from one Master to one slave, but in the near future it seems that
> the environment would extend to about five slaves.
We are currently using eRServer for the .info registry, and starting
next week it will also underpin the .org registry. Dunno if that's
g
e following error:
> ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory
Is that a failure on zlib? If you do (just guessing) --without-zlib
does it help?
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS To
queries as
well, that will allow you to distinguish what is taking how long.
Andrew
1/22/03 11:20:15 PM, "shreedhar" <[EMAIL PROTECTED]> wrote:
>Hi All,
>I would like read time taken by each query in my triggers.
>so i created a temporary table and in
On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
>
> the eRServer is for free or not ?
"Not", as far as I know. Its baby cousin is in contrib/rserv in the
source tree. I haven't tested it with 7.3, so I don't know whether
it works.
A
u could lower your TCP timeout, I guess, but
I believe the TCP/IP authorities say this is a Bad Idea.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]>
Use your postgresql.conf file to enable logged connections:
log_connections = on
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED
f _Practical PostgreSQL_ discusses various
"versions", one of which is the Command Prompt PostgreSQL. That may
be the source of confusion. (My copy is at the office, and probably
on someone else's desk, so I can't check right now.)
A
--
Andrew Sullivan
, is just says "query was cancelled" or
something like that).
If you can post printouts of log files, probably people more competent
than myself can help you figure out the details of your problems.
Andrew
Ben Jordan wrote:
Message
I'm
very new to all this so I a
7;m afriad not. The techdocs.postgresql.org site has some
suggestions, though.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
All the docs. are in:
http://www.postgresql.org/docs/
If you select "Interactive Documentation" you can do searches
(recommended for your specific question), otherwise you can go to
"Static Documentation" and look up the syntactic details of "SELECT".
Andrés Repossi wrote:
Hi,
I'm trying to
You are not transparent, although you do seem to be somewhat sensitive.
I saw at least one posting from you that was answered by 2 different people.
If you got no answers to your questions, it may be that:
- nobody who knew the answer saw your posting (there are lots of
postings, and not many p
On Thu, May 29, 2003 at 09:36:55AM +0530, rakesh wrote:
> How can the numbers be resolved to names?
contrib/oid2name
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PRO
en't used Opterons, but I'm curious how that argument works.
I've never seen any evidence that MySQL is better with large
databases than PostgreSQL; am I just out of touch?
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
I recommend you look at chapter 5, "Data Types", of the PostgreSQL
User's Guide.
[EMAIL PROTECTED] wrote:
Hello ALL.
Where can I find (and set if need) all defined max length restrictions of PostgreSQL
server.
for example,
max lenght of VARCHAR,
or any variable-length array,
or max query len
On Thu, Jun 05, 2003 at 10:12:25AM -0400, Vinay wrote:
> figured that it is because I have to do the init db everytime this
I don't know anything about the Cyg Win installation, but you _don't_
need to do initdb every time: that creates a new data area.
A
An
s like you don't have a C compiler in your $PATH. You need one,
or you can't compile C programs. Install one, or adjust your $PATH
to include it.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toront
y dump, and then immediately afterward create the
> replication tables in the master. Since the dump is transactional (is it?),
You might miss something this way.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
he general
postgres.log, /var/log/postgres.log on my system.
ap
------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On W
lly concluded that once the buffer was full, managing
it was making the system crawl.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
On Wed, Jul 09, 2003 at 09:52:38AM +, aris wendy wrote:
>
> I want to kill process no 582, I use kill -9 582 but all user become
> disconnect look at below
Try kill -2.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
Monica,
Come ha suggerito Gaetano Mendola, per quanto ho visto tutti gli utenti di
questa lista comunicano in inglese; e sicuramente, la maggior parte di quelli
che hanno le risposte sembrano non avere nomi italiani.
Se hai gia` trovato la risposta al tuo problema, benissimo.
Se no: se il
unt it a vote in favor.
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Andrew Biagioni
ze!
Could be that your free space map is too small; on 7.2, the default
is at least an order of magnitude too small. Also, perhaps you need
to reindex: the btrees in Postgres have a nasty habit of growing
without bound. (That's fixed in current CVS sources.)
A
--
Andrew Sulliva
7/18/03 10:06:29 AM, "scott.marlowe" <[EMAIL PROTECTED]> wrote:
>On Thu, 17 Jul 2003, mlaks wrote:
>
>> Hi,
>>
>> I have about 15 different PC's running RedHat 7.3 Linux, each running the
>> same database backed application (I use Postgresql 7.2.1 for the database)
>> on each machine.
>
>Upg
stand that, but it's
definitely battle-tested.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
7/22/03 3:32:03 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
>On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote:
>> I am having a hard time selecting a Replication/Failover/HA solution for
>> PGSQL. What is troubling is the number of solutions available in
On Tue, Jul 22, 2003 at 05:25:28PM -0400, Andrew Biagioni wrote:
> Sorry -- by "production", what release version do you mean?
eRServer v1.0
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<
test your solution and thanks for
> making it available to the public.
Don't thank me -- it's PostgreSQL, Inc. that's releasing it, 'cause
it's their code. I'm just a waterboy.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
http://www.debian.org/doc/manuals/reference/ch-system.en.html#s-boot
At base, however, you want to use one of the sample rc scripts into
/etc/rc[n].d , and make a symlink to it from /etc/init.d. I believe
the details are covered in the section of the doc I mention above.
A
?
Well, I'm not too sure how correct that is (how do you know _all_ the
data is there), but you could try pg_resetxlog. I'd go looking for
data in an inconsistent state afterwards, though.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
On Wed, Jul 30, 2003 at 01:23:25PM -0400, Andrew Sullivan wrote:
>
> At base, however, you want to use one of the sample rc scripts into
> /etc/rc[n].d , and make a symlink to it from /etc/init.d. I believe
Doh! The other way around, actually. Boy, it's embarassing
tripping
ions of tracking as determined by your FSM settings.
VACUUM FULL actually shortens the data file. Except for cases having
to do with large tuples that won't fit in the previous page, VACUUM
FULL means that you can't fit any more data in that file, once the
VACUUM FULL is done.
A
--
.
> available until i do a full vacuum, correct? (at which time the
> file size(s) will indicate the amount being used)
That's right, yes.
> just started looking at fsm. thanks for the pointer there. i hope
> i'm not acting too obtuse here.
Nope. If you don't ask, you
On Thu, Jul 31, 2003 at 12:00:49PM -0700, Daniel Gerardo Lucero Baylon wrote:
> Does exist a way to start Postgre as root?
su -c "your command here" postgres
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, O
there on the server.
Not at the moment. You could use a replication system to solve this
for you, though. See contrib/rserv, the recent improvements to rserv
available on gborg (I haven't used them), contrib/dbmirror, or the
soon-to-be-released _other_ improvements to contrib/rserv.
A
--
---
ions on fail over:
1. Make sure your sequences are up to date. This is the sort of
thing you need to build a script for in advance.
2. It's good to have a policy about how much data you can afford
to lose. If the answer is, "none", you need to invest in some very
expensive h
n't be recycled for others to use. There is no
choice but to reindex certain indexes. You can use pgstattuple and
oid2name to get some idea of what is taking all the space, and
thereby be selective.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS
me time late this afternoon (uh, EDT), I
think you'll stumble on it.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
ing didn't get changed. We can fix that.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
completely (queries
will run as long as they need to).
Andrew
8/29/03 2:35:04 AM, "Yudha Setiawan" <[EMAIL PROTECTED]> wrote:
>
>
> From: "Yudha Setiawan" <[EMAIL PROTECTED]>
>
> To: <[EMAIL PROTECTED]>
> Subject:[ADMI
lift told me why -- I just need
to fix it.
You can get the xerces jar file independently for the time being if
need be.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]>
t's my fault. I'll fix it.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
r unique indexes on two columns: say, the row id (just
a type serial) plus a server id (which was static for everything in
that database),
There are plenty of practical problems with such a scheme, and it
seems to me a little fragile, but it'd work.
A
--
Andrew Sullivan
ely and I'm behind on my list responses.)
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
d users grow, be able to distribute the
computing/storage/memory load among various machines rather than have to
upgrade the hardware
Thanks in advance!
Andrew
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
Thanks -- I haven't looked at schemas, I guess I will now :-).
As for stability -- I was referring to the hardware breaking down, not
Postgresql!
Andrew
9/11/03 5:24:50 PM, "scott.marlowe" <[EMAIL PROTECTED]> wrote:
>You might want to consider using schemas to
experience) because
the holding table will gradually build up a lot of dead tuples.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMAIL PROTECTED]> M2P 2A8
f design, but I
think it was because we had some transactions which ran long and
depended on the summarised results. But if it works for you, great.
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<[EMA
mechanisms (crypt, password, sameuser, etc.) cause a "permission denied"
failure. The same script works fine under solaris. Any ideas?
Thanks.
-----
Andrew J. Perrin - [EMAIL PROTECTED] - NT/Unix Admin/Support
Dep
, for example, access to our departmental database run as 'dtwww' (a
user without a shell), and use the above to create the user not as nobody
but as dtwww.
hope this helps.
-----
Andrew J. Perrin - [EMAIL PROTECTED] - NT/Uni
st_name) values ('perrin');
INSERT 964544 1
demogdata=> \q
-
Andrew J. Perrin - [EMAIL PROTECTED] - NT/Unix Admin/Support
Department of Demography-University of California at Berkeley
2232 Piedmont Avenue #2120 -
Architecture: Solaris 2.6 Sparc
Compiler: gcc 2.95.1
postgres versionpostgres-v6.5.3
I am getting this no matter what value I pass to postmaster -B. There is
something else going on here. I did have some problems with the compile but
got the problems worked out. Any suggestions
no danger of a race condition (another user creating a record in
the time between your creating the record and calling currval); BUT
- You must be using the same backend as you did on the creation.
Hope this helps.
-----
Andrew J.
http://www.sunfreeware.com/faq.html#q0 gives details on getting gzip onto
your system. There are also copious instructions on how to install
everything.
-
Andrew J. Perrin - [EMAIL PROTECTED] - NT/Unix Admin/Support
Department
he thought was that we could put them
all onto one high availability machine as instances under 1 postgres
install.
Is there any documented way of doing that or does anyone have experience of
doing that they would like to share with me.
Any information is appreciated.
Regards
--
Andrew Delamare
Postgres Admin Wizards,
I am trying to manage an 8.4 database whose ingest rate is
sufficiently high that doing base backups on it causes it to fall
unacceptably behind. To deal with this, I want to do WAL shipping to
another server that is in warm standby mode, and then on that server
perform th
These functions aren't actually doing anything overly magical. They
don't cause you to end up with a "nice clean snapshot", at least not
right away. They're mostly just helping with the housekeeping tasks of
making sure that in the future you have kept around the WAL segments
that will be necessar
Going with your first option, a master->slave replication, has the
added benefit that you build the expertise for doing Continuous Point
In Time Recovery, and after you do this storage system migration you
can use that knowledge to put in a place a permanent standby server.
Yes, it is a bit of work
, user_name;
EXECUTE ''GRANT '' || privilidge || '' ON '' || row.relname || '' TO '' ||
user_name;
END LOOP;
RETURN ''t'';
END;' LANGUAGE 'plpgsql';
SELECT multi_grant('select'
ner_idx ON pet(owner);
Anyway, I hope this is enough to get you pointed in the right dirrection.
Feel free to ask me for more details.
- --
Andrew G. Hammond mailto:[EMAIL PROTECTED] http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
e database system. That stuff can be
controlled by GRANT and REVOKE.
- --
Andrew G. Hammond mailto:[EMAIL PROTECTED] http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursi
displays the query used by psql to list permissions in the filesystem:
SELECT relname as "Relation",
relacl as "Access permissions"
FROM pg_class
WHERE relkind in ('r', 'v', 'S') AND
relname !~ '^pg_'
ORDER BY
x, it is
/usr/lib/postgresql/bin/pg_controldata
You should be able to find it quickly using
% locate pg_controldata
Alternately, if your system isn't properly maintained (and, unless you've got
some seriously nice hardware, this will take some time: grab a coffee while
you wait...), try
%
ill be granted access as user "puser".
>ANY IDEAS?
Have each user log in from the same UNIX account.
Instead of trying to make all users into one user, which is almost never
a good idea, why not just use the PUBLIC concept in the database's
access control system? Give ea
ome new stuff to deal with this
issue.
> and how will 7.2 be different, I remember a background vacuum
> being discused, what other great things are there waiting in
> the wings
Er... RTFM: http://developer.postgresql.org/todo.php stuff that's
slated for 7.2 has a - in fro
ipe
> ERROR: copy: line 1, Cannot insert a duplicate key into unique index
> rox_group_graph_pkey
> FATAL 1: Socket command type \ unknown
> ERROR: copy: line 1, Cannot insert a duplicate key into unique index
> rox_granted_permission_pkey
> pq_flush: send() failed: Broken pipe
> F
ry and activate the postmaster, back up the DB, and try
creating a new one. However, postmaster would not launch either, and I was
prompted with the same error above.
I'm not quite sure what I need to do to repair this problem. If someone
could give me some direction it would be very
301 - 388 of 388 matches
Mail list logo
