fers the service from S824, which I consider to be
the correct behavior.
So, the problem boils down to c). Can somebody please tell
me what causes c) to go to remote server? And how I can
correct it to behave like user J?
Thank you.
Tena Sakai
[EMAIL PROTECTED]
highly appreciated.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Hi,
I have looked at documentation on the web. For example,
http://www.postgresql.org/docs/8.2/interactive/index.html.
Is there any place I can get it in pdf (or some other printer
friendly) format? I thought I had seen it on my distribution,
but I cannot locate it.
Thank you.
Tena Sakai
he data is under
way. Thanks for your comment.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Fri 7/27/2007 6:16 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] my postgres is dead. need help!
On 7/27/07, Tena Sak
Many thanks, Devrim.
Tena
-Original Message-
From: Devrim GÜNDÜZ [mailto:[EMAIL PROTECTED]
Sent: Sat 7/28/2007 1:06 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] documentation question
Hi,
On Fri, 2007-07-27 at 17:25 -0700, Tena Sakai wrote:
> I have loo
Many thanks, Vishal.
Tena
-Original Message-
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Sat 7/28/2007 3:38 AM
To: Tena Sakai
Subject: RE: [ADMIN] documentation question
you can get the pdf format on -
http://www.postgresql.org/files/documentation/pdf/8.2/postgresql-8.2-A4.pdf
an?
Can anyone please explain what this means? If you have done
what I am trying to do, please furnish a working example.
Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
352 of 8.2.1
manual:
ldap://ldap.example.net/dc=example,dc=net;EXAMPLE\
means, I would appreciate it greatly.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tue 8/7/2007 9:31 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject:
postgresql.conf file (also in the data directory)?
Thank you in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Hi Joshua,
Hi Kevin,
Many thanks for your suggestions/advices.
I am reading chapter 17 of the manual, which in the hindsight,
I should have read a month ago. But this is very good. I am
making haste slowly.
Thanks again.
Regards,
Tena Sakai
[EMAIL PROTECTED
pect to see the
logged lines be prefixed with username, database name, timestamp,
etc with all other things intact? I come from change-as-few-
things-as-possible-at-one-time-school.
Thank you in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Joshua D. Drake
Hi Tom,
Thanks. I will live a bit dangerously while I
strategize what to do with the logfile. I am
not sure if 7 day log rotation is really a
wise option for now. I will come up with
something fitting in time. Thanks for your
comment, nonetheless.
Regards,
Tena Sakai
[EMAIL PROTECTED
e
second line indicates where the database cluster resides.
In my case it is /usr/local/pgsql/data. The last line has
two numbers. In my case they are: 5432001 and 131072.
What do they represent? I don't seem to have processes
by such id.
Thank you in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
directory removed.
Regards,
Tena
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/13/2007 3:37 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postmaster.pid file
"Tena Sakai" <[EMAIL PROTECTED]> writes:
>
Hi Tom,
An excellent suggestion and I've just done it.
Many thanks.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/13/2007 4:21 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postmaster.pid file
"
Hi everybody,
After adjusting checkpoint related entries in postgresql.conf
file, is it sufficient to issue:
pg_ctl reload
Or am I supposed to do more than that?
Thank you in advance.
Tena Sakai
[EMAIL PROTECTED]
f there is no activity?
The last entry I see in the serverlog file is:
2007-08-20 16:47:51.152 PDT] < >LOG: received SIGHUP, reloading
configuration files
Thank you.
Tena
-Original Message-
From: Farhan Mughal [mailto:[EMAIL PROTECTED]
Sent: Mon 8/20/2007 5:16 PM
To: Tena
Many thanks, Tom.
Tena
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/20/2007 9:12 PM
To: Tena Sakai
Cc: Farhan Mughal; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] After adjusting checkpoint related entries in
postgresql.conf...
"
inspection of tar's messages.
GNU tar is therefore not the best tool for
making base backups.
On my linux machine, gnu tar is the tar. Does
anybody have a suggestion as to where I can go
to get a tar that is not gnu?
Thanks in advance.
Tena Sakai
[EMAIL PROTECTED]
PROTECTED]
Sent: Tue 8/21/2007 6:02 PM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] tar, but not gnu tar
>>> On Tue, Aug 21, 2007 at 7:28 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
>
> On my linux machine, gnu t
Thanks, Ken.
I just glanced at man page for star. It looks promising
and I will experiment with it. This may be the ticket.
Regards,
Tena
[EMAIL PROTECTED]
-Original Message-
From: Kenneth Marshall [mailto:[EMAIL PROTECTED]
Sent: Wed 8/22/2007 5:30 AM
To: Tena Sakai
Cc: Kevin
exit codes
in the man pages. That's not good. Rsync man page has a section where
all exit code is listed, but I have no foreign drive on this host. I
am tempted to get a tiny machine just to do the backup.
I'd be interested your insights and thoughts.
Regards,
Tena
-Original Mes
ytes (total of 4295342080 bytes = 4194670.00k).
I am inclined to use star. At the bottom of the star man page,
the author Joerg Schilling gives out his email address (3 of
them!) and I will email him and ask if he can supply a list of
all exit codes.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Hi Bruce,
> This seems to contradict what we say about GNU tar?
> Is this GNU tar? What version?
Yes, it is GNU tar v1.14
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Thu 8/23/2007 12:02 PM
To: Tena Sakai
Cc: To
out.
What does this mean? Is postgress listening on port
5432?
Regards,
Tena Sakai
[EMAIL PROTECTED]
ist are dhcp clients
and their ip addresses change from time to time.
Is there something I can do to accomodate such
moving targets?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Kevin Kempter
Sent: Tue 9/4/2007 10:09 AM
To: pgsql-admin@po
Many thanks, Kevin.
'*' is a bit too wide for my taste. I wonder
if it is possible to specify something like
network mask (or range)? I may be a bit
paranoid, but...
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Kevin Kempter
Hi Kevin.
I had to read your message twice and look at
pg_hba.conf file, but I am now clear. Yes,
a big difference between listen *on* and
listen *to*.
Many thanks.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Kevin Grittner [mailto:[EMAIL PROTECTED]
Sent: Tue 9/4/2007 11:54
6 million rows.
I don't suppose there is anything I can do to prevent
such failure (short of installing more memory)?
Regards,
Tena Sakai
[EMAIL PROTECTED]
,
Tena
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tue 9/11/2007 8:58 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] out of memory
"Tena Sakai" <[EMAIL PROTECTED]> writes:
>> canon=3D# select * f
Many thanks, Tom and Tino.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wed 9/12/2007 7:20 AM
To: Tino Schwarze
Cc: pgsql-admin@postgresql.org; Tena Sakai
Subject: Re: [ADMIN] out of memory
Tino Schwarze <[EMAIL PROTECTED]>
cannot turn my workstation off.
Can somebody please tell me what's happening? And
how would I fix this?
I am running postgres 8.2.4 on dell, redhad linux
enterprise server.
Thank you in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
start, not reload. Of course, now that I am
looking for such section of the manual, I cannot find it.
Maybe I just daydreamed it...
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Kevin Grittner [mailto:[EMAIL PROTECTED]
Sent: Wed 9/19/2007 11:23 AM
To: Tena Sakai; p
at can/Should
I do to remedy the situation?
My environment is Redhat Linux, Dell AMD 64bit machine
with postgres 8.2.4.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Many thanks, Scott.
Tena Sakai
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thu 10/11/2007 10:03 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] failure on 'pg_ctl stop' command
On 10/11/07, Tena Sakai <[EMAIL PROT
me as to:
ERROR: relation "newschema" does not exist
How can I do what I want to do?
Thank you in advance.
Tena Sakai
[EMAIL PROTECTED]
Many thanks, Milen.
Tena
-Original Message-
From: [EMAIL PROTECTED] on behalf of Milen A. Radev
Sent: Fri 11/2/2007 5:18 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] schema privilege question
Tena Sakai ??:
> Hi everybody,
>
> I just created a new schema.
is indicative of any underlying
issue(s). Would you please let me know what
you know?
Thank you.
Tena Sakai
[EMAIL PROTECTED]
rogram using jdbc to
issue postgres commands. However, I see the same message via
psql (on the same machine).
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Fri 11/9/2007 2:11 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subje
be caused by many deleted
rows from tables (and having neglected to vacuum)?
Tena Sakai
([EMAIL PROTECTED])
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Fri 11/9/2007 3:03 PM
To: Scott Marlowe
Cc: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] idle in
Thank you!
Tena
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Fri 11/9/2007 4:29 PM
To: Tena Sakai
Cc: Tom Lane; Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] idle in transaction...unexpected EOF on clientconnection
Tena Sakai escribió
-14 09:39:22.841 PST] ERROR:
relation "msysconf" does not exist
[2007-11-14 09:39:22.842 PST] STATEMENT: SELECT Config, nValue FROM MSysConf
Many thanks in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
NFO: "allele": scanned 3000 of 10478 pages, containing 36 live rows and 0
dead rows; 3000 rows in sample, 1257360 estimated total rows
I would appreciate it if you could give me a bit of
interpretation from psql.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
F
Hi Scott, Kevin, Alvaro, and everybody else:
Many thanks for your help and advices. After vacuuming
and reindexing all tables, my nightly run zipped right
through at amazing speed.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED
Many thanks, Usama!
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Usama Dar [mailto:[EMAIL PROTECTED]
Sent: Fri 11/30/2007 1:24 PM
To: Tena Sakai
Cc: Jonah H. Harris; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Dec 1, 2007 1:34 AM, Tena Sakai
Many thanks, Jonah!
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Sent: Fri 11/30/2007 1:17 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Nov 30, 2007 3:34 PM, Tena Sakai <[EM
Many thanks in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
postgres tool I
can use?
Thank you.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Sent: Fri 11/30/2007 12:03 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] connection limit exceeded
On Nov 30, 2007
? Would
this mean something is in a hung state?
Regards,
Tena Sakai
[EMAIL PROTECTED]
Hi Scott,
Thank you for an enlightening example! I see
it and I believe it.
My next question:
What would be a good way to tell if some
query is hung?
Regards,
Tena
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thu 12/13/2007 11:47 AM
To: Tena Sakai
Cc: pgsql
control-C, he/she gets a notion that it is aborted, but
as far as postgres is concerned the query keeps running for
days and days? Is there any way to detect such has indeed
taken place?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of
for 2+ days.
But question still remains in my mind: is this a
strayed process or is this simply a long running
(and meaningful) process?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: brahma tiwari [mailto:[EMAIL PROTECTED]
Sent: Fri 12/14/2007 4:21 AM
To: Tena Sakai
Subjec
d after 4 or 5 days they seem
to have finished running. So the problem does not
really exist anymore, except that I take a bit of
academic interest in what's going on and how to
cope with it in the similar situations in the future.
Thanks for your insight and kindness.
Regards,
Tena Sakai
[E
any way to explicitly close
this table?
The only other solution I can think of would be to
shutdown and restarting the database, which is what
I would like to avoid, if possible.
Any suggestions are welcome.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Thank you, Tom!
> Some other session holding an exclusive lock on the table, perhaps?
That is exactly the case.
I see what I must do. Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 12/17/2007 4:11 PM
To: T
ve
from killing it, if any?
Thank you.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 12/17/2007 4:11 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How would I "close" a atble?
"Tena Sak
Hi Tom,
> What you have not shown us is what transaction has
> actually *got* a lock on 16496.
Would you mind enlightening me as to how I can do so?
I stared at the output from pg_locks a long time and
just can't get more than what I had gotten out of.
Regards,
Tena Sakai
[EMAI
| 22833 | t
I kept looking at the ones I emailed to you which
omitted a few rows from the bottom. That was dumb!
I issued "kill -INT 22833" and in a few minutes
pg_locks view shrunk to 2 rows from 41 rows.
Many thanks for following up with this problem.
Regards,
Tena Sa
happens that the application is
issuing a long query with a few ANDs and what appears
in the current_query column does not seem to be the
whole thing. Is there any way I can look at the
entire query string?
Thank you.
Tena Sakai
[EMAIL PROTECTED]
ly if one is
already running 8.3.x? (Even that is a bit strange, since
the last minor rev number is only 0 at this time...)
Assuming I am wrong (ie., what it says does apply to me),
where in the steps (after 4 and before 8) do I make the
backup?
I'd appreciate someone to de-confuse me.
Re
new (8.3.0)
that I just installed via step 4 to dump the database
that's not up? And would I have done steps 5 through 7?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Chander Ganesan [mailto:[EMAIL PROTECTED]
Sent: Mon 2/11/2008 11:47 AM
To: Tena Sakai
Cc: pgsql-
d wanting to go from 8.2.4 to 8.3.0.
Would you please tell me where I might find
documentation/references to run multiple versions
of postgreSQL on one OS?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 2/11/2008 1:39 PM
To: Chan
reciate your thoughts/critique on what I
outlined.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Peter Childs
Sent: Mon 2/11/2008 11:56 PM
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] 8.3.0 upgrade, confused by documentation
On
Hello Markus,
Fantastic! I have a few more (manual and reference)
pages to read, but I am definitely warming up to the
challenge.
Many thanks for your (and others') reply and thoughts.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Markus Bertheau [mailto:[
ke install --build-new-dir pgsql-8.3.0
I would assume former, but I want to be sure.
Thank you in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Many thanks, Tom!
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wed 2/13/2008 7:32 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] more 8.3.0 upgrade question
"Tena Sakai" <[EMAIL PROTECTED]>
se tell me what's going on and how to go
about getting out of the trouble I am in?
Regards,
Tena Sakai
[EMAIL PROTECTED]
rust.' Now all seems fine. I will spend a bit more
time verifying that all tables are intact, but so far
I have a good feelings.
Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-----
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Sat 2/23/2008 6:57 P
. .bashrc
echo PGUSER: $PGUSER
echo PGDATABASE: $PGDATABASE
echo PGHOST: $PGHOST
echo PGPASSFILE: $PGPASSFILE
echo PGDATA: $PGDATA
and everything it told me checks out with what I get from
interactive session.
Please tell me what I am doing wrong. I am at the
end of my wits.
Regards,
Tena Sakai
[EMAIL PROTECTED]
ord:
pg_dumpall: could not connect to database "template1": fe_sendauth: no
password supplied
I just don't get it...
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Phillip Smith [mailto:[EMAIL PROTECTED]
Sent: Wed 2/27/2008 5:19 PM
To: Tena Sakai; pgsql-admin@post
have any suggestion in a
similar fashion.
I am all ears.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Wed 2/27/2008 5:40 PM
To: Phillip Smith; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] trouble with pg_dumpall
Hi Phi
Hi Phiilip,
Here it is.
Tena
# PostgreSQL Client Authentication Configuration File
# ===
#
# Refer to the "Client Authentication" section in the
# PostgreSQL documentation for a complete description
# of this file. A short synopsis follows.
#
# Th
Regards,
Tena
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Wed 2/27/2008 6:59 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] trouble with pg_dumpall
On Wed, 27 Feb 2008, Tena Sakai wrote:
> Hi Jeff,
>
> Thanks for your reply, but
n see, I am afraid my point still holds.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Steve Holdoway
Sent: Wed 2/27/2008 7:33 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] trouble with pg_dumpall
On Wed, 27 Feb 2008 17:12:40
it
back to the way normally is (md5). I would rather
not do that and get .pgpass or PGPASSFILE to work
for me.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Wed 2/27/2008 7:41 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.o
so that we can see
> what's really going on?
Yes, it is running and I expect it to go for another
10 to 15 minutes. I will get your the result asap.
Thank you for your invariable assistance.
I am getting excited.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
F
s/bin:/usr/local/java/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/ant/bin:.
|--|
*:5432:canon:postgres:mysecret
|--|
Password:
pg_dumpall: could not connect to database "template1": fe_sendauth: no password
supplied
Regards,
Tena Sakai
[EMAIL PROTECTED]
Yha!
That did, Jeff! Fantastic!
*:5432:canon:postgres:winkwink <- no good
*:5432:*:postgres:winkwink <- works!
Many thanks to Jeff and everybody else who
stayed with me to see the end of this saga.
I appreciate it wholeheartedly.
Regards,
Tena Sakai
[EMAIL PRO
correctly and restart. But it refuses to go down as
shown above. I then tried to use psql:
$ psql canon
and it tells me:
psql: FATAL: the database system is shutting down
Can I kill the process 11148 and do as I planned accordingly?
I would appreciate any pointers.
Regards,
Tena Sakai
[EMAIL
is shutting down
[2008-03-24 15:52:43.563 PDT] FATAL: the database system is shutting down
I am about to try:
pg_ctl stop -m immediate
Regards,
Tena Sakai
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 3/24/2008 3:11 PM
To: Tena Sakai
Cc: pgsql-admin@postgresq
Hi Scott,
> did you try pg_ctl -m immediate stop ???
I just did, and it worked.
$ pg_ctl stop -m immediate
waiting for server to shut down done
server stopped
Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EM
14526 ?Ss63:15 postgres: ysu canon 127.0.0.1(44853) idle
16563 ?Ss 2:06 postgres: autovacuum worker process canon
21201 pts/8S+ 0:00 grep post
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Peter Koczan [mailto:[EMAIL PROTECTED]
Sent:
Many thanks, Peter.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Peter Koczan [mailto:[EMAIL PROTECTED]
Sent: Thu 3/27/2008 2:59 PM
To: Tena Sakai
Cc: Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] it refuses to go down...
> > I had to dea
othing complicated
about running it) and you might find out a thing or two that is insightful.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Johann Spies
Sent: Tue 4/8/2008 2:42 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Handling la
experience.
Also in a recent linux magazine (I don't know if
that's your platform or not, but...) there was
this article: http://www.linux-mag.com/id/5679
which may be a good source of information.
Hope this helps.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
Fr
/pgsql/lib/libpq.so.5.1
~postgres is /usr/local/pgsql which is a
symbolic link to /pgsql/pgsql. Is this a cause
of the problem? And how would I "fix" this from
crontab?
Regards,
Tena Sakai
[EMAIL PROTECTED]
Hi Everybody,
I found a solution by trial and guessing.
I explicitly coded:
LD_LIBRARY_PATH=/usr/local/pgsql/lib
in the crontab file. That seems to have
done it.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Mon 4/14
ame
.
.
Hope this helps.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Ryan Wells
Sent: Sat 4/12/2008 5:59 PM
To: Ryan Wells; pgsql-admin@postgresql.org
Subject: [ADMIN] Slow pg_dump
We're having what seem like serious performance issues with
grab the correct set of files to upgrade to the latest
postgres, v8.3.3?
I have been to the postgres website and via File Browser, I got to:
Top ? binary ? v8.3.3 ? linux ? rpms ? redhat ? rhel-4-x86_64
Am I at the right place?
Please advise.
Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
Thank you, Joshua!
Tena Sakai
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Thu 6/19/2008 10:00 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] where would I find the files I need?
Tena Sakai wrote:
> Hi everybody,
>
> I a
so, do I need to spell it out if I am
logged in as user postgres? If not, what is this?
Please advise. I would appreciate it.
Thank you.
Tena Sakai
[EMAIL PROTECTED]
uld appreciate
it if you could elucidate.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 3:18 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
On Fri, 22 Aug 2008, Tena Sakai
Many thanks, Jeff. I appreciate it. (And I will take
this opportunity to look at the dump file, if nothing
else, to satisfy my curiosity.)
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 3:54 PM
To: Tena Sakai
Cc
e a better idea/suggestions?
Please advise.
Thank you.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-----
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Fri 8/22/2008 3:56 PM
To: Jeff Frost
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Many tha
nd:
drop database
then repeat what I did from shell prompt, ie.,
zcat | psql postgres > restore.out 2 > restore.err
Would you mind confirming if I am understanding you correctly?
Many thanks for your assistance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
Fro
this catch-22 situation?
Any advice appreciated.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 10:28 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from dump
Jeff Frost wrote:
> Ten
t the time very close to
my issuing dropdb.
What are my options now?
Thank you.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Sat 8/23/2008 10:29 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] restoring from dum
ave had a series of power outages
and maybe they got lost as a result. I am not convinced,
however.
Instead of your dd suggestion, I thought of copying
0084 and calling it 0085. I have no idea what consiquence
there might be. Perhaps, you can comment?
Regards,
Tena Sakai
[EMAIL PROTECTED]
anybody have notion
as to how long they should be kept, what recycling
policy there ought to be, etc?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Marcelo Martins [mailto:[EMAIL PROTECTED]
Sent: Mon 8/25/2008 7:06 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re
Hi Alvaro,
I just looked in pg_clog directory and there is
only one file:
-rw--- 1 postgres postgres 24576 Aug 25 20:18
I saw the same file about 10:30 am and I believe
it was roughly the same size. This is a brand new
installation of 8.3.3.
Regards,
Tena Sakai
[EMAIL PROTECTED
1 - 100 of 185 matches
Mail list logo