[ADMIN] getting service from a local server (v8.2.4)

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]

[ADMIN] my postgres is dead. need help!

highly appreciated. Regards, Tena Sakai [EMAIL PROTECTED]

[ADMIN] documentation question

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

Re: [ADMIN] my postgres is dead. need help!

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

Re: [ADMIN] documentation question

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

Re: [ADMIN] documentation question

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

[ADMIN] postgres authentication

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]

Re: [ADMIN] postgres authentication

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:

[ADMIN] entries in serverlog file

postgresql.conf file (also in the data directory)? Thank you in advance. Regards, Tena Sakai [EMAIL PROTECTED]

Re: [ADMIN] entries in serverlog file

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

Re: [ADMIN] entries in serverlog file

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

Re: [ADMIN] entries in serverlog file

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

[ADMIN] postmaster.pid file

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]

Re: [ADMIN] postmaster.pid file

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: >

Re: [ADMIN] postmaster.pid file

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 "

[ADMIN] After adjusting checkpoint related entries in postgresql.conf...

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]

Re: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

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

Re: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

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... "

[ADMIN] tar, but not gnu tar

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]

Re: [ADMIN] tar, but not gnu tar

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

Re: [ADMIN] tar, but not gnu tar

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

Re: [ADMIN] tar, but not gnu tar

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

Re: [ADMIN] tar, but not gnu tar

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]

Re: [ADMIN] tar, but not gnu tar

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

[ADMIN] default port number

out. What does this mean? Is postgress listening on port 5432? Regards, Tena Sakai [EMAIL PROTECTED]

Re: [ADMIN] default port number

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

Re: [ADMIN] default port number

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

Re: [ADMIN] default port number

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

[ADMIN] out of memory

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]

Re: [ADMIN] out of memory

, 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

Re: [ADMIN] out of memory

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]>

[ADMIN] log entries are not getting into log file

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]

Re: [ADMIN] log entries are not getting into log file

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

[ADMIN] failure on 'pg_ctl stop' command

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]

Re: [ADMIN] failure on 'pg_ctl stop' command

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

[ADMIN] schema privilege question

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]

Re: [ADMIN] schema privilege question

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.

[ADMIN] idle in transaction...unexpected EOF on client connection

is indicative of any underlying issue(s). Would you please let me know what you know? Thank you. Tena Sakai [EMAIL PROTECTED]

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on clientconnection

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ó

[ADMIN] postgres bogged down beyond tolerance

-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]

Re: [ADMIN] postgres bogged down beyond tolerance

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

Re: [ADMIN] postgres bogged down beyond tolerance

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

Re: [ADMIN] connection limit exceeded

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

Re: [ADMIN] connection limit exceeded

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

[ADMIN] connection limit exceeded

Many thanks in advance. Regards, Tena Sakai [EMAIL PROTECTED]

Re: [ADMIN] connection limit exceeded

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

[ADMIN] reading pg_stat_activity view

? Would this mean something is in a hung state? Regards, Tena Sakai [EMAIL PROTECTED]

Re: [ADMIN] reading pg_stat_activity view

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

Re: [ADMIN] reading pg_stat_activity view

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

Re: [ADMIN] reading pg_stat_activity view

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

Re: [ADMIN] reading pg_stat_activity view

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

[ADMIN] How would I "close" a atble?

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]

Re: [ADMIN] How would I "close" a atble?

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

Re: [ADMIN] How would I "close" a atble?

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

Re: [ADMIN] How would I "close" a atble?

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

Re: [ADMIN] How would I "close" a atble?

| 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

[ADMIN] current_query column of pg_stat_activity view

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]

[ADMIN] 8.3.0 upgrade, confused by documentation

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

Re: [ADMIN] 8.3.0 upgrade, confused by documentation

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-

Re: [ADMIN] 8.3.0 upgrade, confused by documentation

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

Re: [ADMIN] 8.3.0 upgrade, confused by documentation

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

Re: [ADMIN] 8.3.0 upgrade, confused by documentation

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:[

[ADMIN] more 8.3.0 upgrade question

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]

Re: [ADMIN] more 8.3.0 upgrade question

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]>

[ADMIN] 8.3.0 postinstallation trouble

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]

Re: [ADMIN] 8.3.0 postinstallation trouble

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

[ADMIN] trouble with pg_dumpall

. .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]

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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

Re: [ADMIN] trouble with pg_dumpall

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]

Re: [ADMIN] trouble with pg_dumpall

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

[ADMIN] it refuses to go down...

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

Re: [ADMIN] it refuses to go down...

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

Re: [ADMIN] it refuses to go down...

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

Re: [ADMIN] it refuses to go down...

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:

Re: [ADMIN] it refuses to go down...

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

Re: [ADMIN] Handling large volumes of data

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

Re: [ADMIN] PostgreSQL 8.1 to 8.3

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

[ADMIN] "missing" library file

/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]

Re: [ADMIN] "missing" library file

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

Re: [ADMIN] Slow pg_dump

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

[ADMIN] where would I find the files I need?

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]

Re: [ADMIN] where would I find the files I need?

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

[ADMIN] restoring from dump

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]

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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]

Re: [ADMIN] restoring from dump

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

Re: [ADMIN] restoring from dump

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   2   >