Thank you, Shoaib.
Tena
On 11/9/10 6:26 PM, "Shoaib Mir" wrote:
On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai wrote:
Can somebody please tell me how I find who it is using the
x database?
select * from pg_stat_activity where datname = '';
Thank you, Sam.
Tena
On 11/9/10 6:25 PM, "Samuel Stearns" wrote:
Psql template1
Select * from pg_stat_activity;
Sam
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Tena Sakai
Sent: Wednesday, 10 November 2010 12:48 PM
To: p
,
Tena Sakai
tsa...@gallo.ucsf.edu
=/mnt/ami-centos5.5-64bit-base
I would appreciate it if you could tell me anything else
I have to do.
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
gt; If your listen_addresses is wrong,the same error can occur.
My listen_address was set as localhost (and also commented
out, which I decommented), but my PGHOST environment variable
was set as machine. I fixed PGHOST as localhost.
With these two fixes it is now working.
Thank you again.
Regards,
Is the server running on host "172.16.0.151" and accepting
TCP/IP connections on port 6543?
bash-3.2$
Thank you for your help.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
0.151" and accepting
TCP/IP connections on port 6543?
bash-3.2$
Thank you for your help.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Hi everybody,
I have been reading this thread and I got the idea that
SANs to avoid, but would somebody please give a bit of
Comparison/perspective on NAS?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 9/7/10 12:36 PM, "Craig James" wrote:
> On 9/7/10 12:06 PM, Jesper Krogh wrot
Hi Scott,
Thank you for your quick tips. I shall remember zcat (and
hopefully others).
Regards,
Tena Sakai
On 8/24/10 2:30 PM, "Scott Marlowe" wrote:
> On Tue, Aug 24, 2010 at 3:22 PM, Tena Sakai wrote:
>> Having said that, I think Ian is correct that I was mis
bly
Serious, is it? (I will fix it via postgresql.conf file shortly.)
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 8/24/10 12:12 PM, "Kevin Grittner" wrote:
> Tena Sakai wrote:
>
>>gunzip /dumpall20100822.0.gz
>>| /usr/local/pgsql/bin/psql -f * postgres
somebody please tell me why this didn’t work? Also, what must I do to
successfully
restore the database?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Please ignore this mail. I am testing if I can post, since it has failed
recently.
Thank you.
Tena
Hi Greg,
My apologies. I hadn't realized that -At was a combination
of -A and -t. Rather, I kept thinking that t as argument
to -A.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 6/1/10 11:02 PM, "Greg Smith" wrote:
> Tena Sakai wrote:
>> I got it to work by emulatin
Thank you, Alvaro.
Literal tab, that's one thing I never tried.
Yes, it works.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 5/31/10 8:58 PM, "Alvaro Herrera" wrote:
> Excerpts from Tena Sakai's message of lun may 31 21:36:41 -0400 2010:
>
>> But when I do
Many thanks, Greg!
I got it to work by emulating what you wrote.
But I think you meant -A, not -At below.
>> psql -c "select name,setting from pg_settings limit 1" -d postgres -At
>> -F $'\t'
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 5/31/10 8:07 PM, &q
possibilities
such as \\t , "\t", etc that I can think of, but I cannot get an honest to
god tab character to appear as field separator. I can do it from psql
and achieve what I want, but I need to do this from shell level. Any
suggestion what else I can try?
Regards,
Tena Sakai
tsa...@g
Thank you, Gabriele.
Now I realize "context sensitive" nature of field separator.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 5/30/10 1:37 AM, "Gabriele Bartolini"
wrote:
> Tena Sakai ha scritto:
>> Can somebody please tell me what ³|² is called in my example
| 0.125 | 25 | 0.271484
RS1020382 | 2 | 0.417 | 69 | 0.609682
RS11878315 | 2 | 0.335 | 64 | 0.354771
Can somebody please tell me what “|” is called in my example above?
And is it possible to change it from “|” to something else for
display purpose?
Thank you.
Tena Sakai
tsa
Many thanks, Rosser, Sam, and Scott.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 5/18/10 4:26 PM, "Scott Marlowe" wrote:
> (Please stick to plain text posts, as many readers can't read html or
> the formatting gets screwy. This is a plain text mailing list in
> gene
database.) (2) Why pg_restore wouldn't give me listing? And (3)
why the second pg_restore command is upset?
Thank you.
Regards,
Tena sakai
Hi Alvaro,
Thank you for an excellent idea. I'll make note of it.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 12/4/09 5:18 AM, "Alvaro Herrera" wrote:
Tena Sakai wrote:
> Hi Tom,
>
> Please ignore what I wrote before. I got it. I mean I got it compiled
>
.
My apologies.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 12/3/09 10:21 PM, "Tom Lane" wrote:
Tena Sakai writes:
> ... I just tried recompiling it on that machine and it compiles without a
> complaint. I now need to re-compile it on a Intel 32-bit machine running
> c
. Is this an option to configure on the top-level
directory? Can you please tell me how I include it?
Thank you.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 12/3/09 10:21 PM, "Tom Lane" wrote:
Tena Sakai writes:
> ... I just tried recompiling it on that machine and it
find -lpq
collect2: ld returned 1 exit status
Is there any way to extrapolate something a bit more relavant, I wonder.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 12/3/09 8:26 PM, "Yon Lew" wrote:
Just a guess, but it sounds to me like a problem with $LD_LIBRARY_PATH.
Try ru
in /usr/lib
directory. (There is also a symbolic link libpq.so.4 pointing at
libpq.so.4.1 in the same place.)
So, I don't know what the complaint is about.
Can someone please clue me in?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
--
Sent via pgsql-admin mailing
in /usr/lib
directory. (There is also a symbolic link libpq.so.4 pointing at
libpq.so.4.1 in the same place.)
So, I don't know what the complaint is about.
Can someone please clue me in?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
--
Sent via pgsql-admin mailing
machine Y and have
Y's PGHOST environmental variable point to X.
Is this correct? If so, where can I go to get psql only for
A 32-bit linux machine?
If not, please clue me in as to how I can do what I want.
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
--
Sent via pgsql-
Thank you, Guillaume.
Tena Sakai
tsa...@gallo.ucsf.edu
On 11/17/09 9:25 AM, "Guillaume Lelarge" wrote:
Guillaume
psql -d musket -f -
can't I? Aside from styling, there is no functional difference
between two procedures, is there?
Thank you.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 11/16/09 10:42 AM, "Tom Lane" wrote:
Tena Sakai writes:
> Now that I am thinking, maybe the f
; encoded and therefore what I did logically did not copy
any canon tables into musket? Could this be the case?
If so, how would I duplicate an existing database and call it
with a different name?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
--
Sent via pgsql-admin mailing list (pgsql-admin@postg
e way I used psql with the option
(-f -), although I can't see what that would be. The file 20091114.6.gz
was made by:
pg_dumpall | gzip > 20091114.6.gz
Would someone please clue me in?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
--
Sent via pgsql-admin mailing list (pgsql-admin@postg
Thank you, Rosser.
It is interesting to note that -- and "/* ... */"
have slightly different behavior. Former is much
like # in shell or // in some programming languages,
while the latter shows multi-line propensity.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message
Thank you Joshua!
> I believe -- will do what you like;
It sure does.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Wed 10/21/2009 5:41 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN]
ith
psql.
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
e whenever you alter it.
Great idea! That's my ticket to solution.
Many thanks. I appreciate it.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Tue 10/20/2009 1:44 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.
ant to timestamp every row
of each table. The timestamp is strictly to
tell when it was last modified.
Is there any good way to do this?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Tue 10/20/2009 12:24 PM
To: Tena
table. How can I get this out of psql?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Many thanks!
Tena Sakai
-Original Message-
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Thu 8/20/2009 10:58 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Sharing /etc/passwd with PostgreSQL
On Thu, Aug 20, 2009 at 10:31 AM, Tena Sakai wrote
Hi Everybody,
I am interested in following this particular thread,
though, yesterday our mail server went down for a few
hours and I don't have the whole account.
Can somebody please tell me how I could retrieve a
history of this particular thread?
Thank you in advance
Regards,
Tena Saka
Many thanks, Scott and Kevin.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From:Scott Whitney [swhit...@journyx.com]Sent: Fri 6/26/2009
11:26 AM
Try:
drop table "gallo.plate_subject"
with the quotes.
-Original Message-
F
Can someone please tell me what I am doing wrong?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
forgotten that such (/usr/bin/psql)
existed.
If you are upgrading from older version to new version, this may be
an item on your check list.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Hi Scott,
> export PGHOST=vixen
> psql canon
> OR
> psql -h vixen canon
Yes, yes, yes! That is it.
Many thanks.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Mead [mailto:scott.li...@enterprisedb.com]
Sent: Fri 4/10/2009 1:03 PM
To: T
Hi Scott,
Thank you for your reply, but...
postgresql.conf has:
listen_addresses = '*'
Is there anything else I am missing?
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Fri 4/10/2009 12:42 PM
To: Tena Sakai
iate any help. Thank you.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
dmin3, the postgresql
on machine apple rejects you.
If any of this is wrong, let me know.
d) on machine apple, do you have .pgpass file? If so,
is the permission on this file correct?
e) to pgAdmin3, what password are you giving? Apple's
or Orange's?
Regards,
urceid, sourcetablename)
"genotype_subjectid_idx" btree (subjectid)
The column datereplaced gets updated when new and/or conflicting
data arrives. So much for my bright idea...
Thanks just the same.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-----Original Message-
From: Diogene
eindex (and analyze) the table.
Is this a correct understanding?
If it is (and as new rows get added new indexes
are also built for the new rows), the fact that
there is no deletion means there is no necessity
for vacuuming this particular table?
I appreciate any thoughts on this mat
Thank you, Fernando.
Thank you, Kevin.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Fernando Arancibia [mailto:faranci...@iswitch.cl]
Sent: Mon 3/16/2009 4:13 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select into...
Hi, try
insert
Many thanks, Scott.
Tena Sakai
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Mon 3/16/2009 4:12 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select into...
On Mon, Mar 16, 2009 at 5:08 PM, Tena Sakai wrote:
> Hi Everyb
d my_table. Is there any way to
get postgres to do what I want done?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
nn, "FETCH ALL from somePort");
Many thanks.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Tue 3/10/2009 9:55 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] any way to convert date
,
Tena Sakai
tsa...@gallo.ucsf.edu
Hi Andy,
Many thanks! That is the silver bullet I needed.
Hoorey!
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Andreas Wenk [mailto:a.w...@netzmeister-st-pauli.de]
Sent: Sat 2/28/2009 4:01 PM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] grant
chema | Name | Type | Access privileges
+--+--+---
(0 rows)
What can I do?
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tena Sakai
Sent: Sat 2/28/2009 3:04 PM
To: Tena Sakai; Andreas Wenk
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] grant question
Hi
grant select on gallo.unlinkcol1 to galloan;
>> GRANT
It doesn't make sense... I am confused.
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: pgsql-admin-ow...@postgresql.org on behalf of Tena Sakai
Sent: Sat 2/28/2009 2:55 PM
To: Andreas Wenk
Cc: pgsql-admin@postg
775282 | 1890310 | 124 | 2007-10-30 20:13:49.86 | 3000-01-01 12:00:00
(5 rows)
So, I don't know how to cure this problem.
Any hints, poiters are appreciated.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Andreas Wenk [mailto:a.w...@netzmeister-st-pauli.de]
u should grant it
> to a role, then give membership to that role to the user.
That sounds like a good idea. Would you mind showing an exmple?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Sat 2/28/2009 12:04 PM
To
ntax error at or near "to"
LINE 1: grant select on schema_Z.* to user_a;
Please tell me what I command I should issue instead
to get what I want done?
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Many thank, Zongliang.
That was what I was after.
Tena
-Original Message-
From: Quan Zongliang [mailto:quanzongli...@gmail.com]
Sent: Mon 2/23/2009 10:15 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] I want to write an app with C...
> What package would I
in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsd.edu
Hi Peter,
Thanks for your reply and idea. I was up way
past my bed time and my mind was not with my
finger tips. As I followed suggestions from
Scott, I was able to get it to work fast. More
often than not, I push the door, when it is
written on the door: "PULL" :)
Regards,
Of course, Deepak!
I had made an alias for "pg_ctl start ..." and always
had -D setting as /usr/local/pgsql/data. I have been
relying on this alias so much, I completely forgot
that's how actually it gets done.
Thank you.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-O
all this turn out.
BTW, I fixed work_mem back to 512MB.
Many thank you for your kindness and guidance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Sun 2/22/2009 1:43 AM
To: Tena Sakai
Cc: pgsql-ad
Hi,
I am able to revert back to 8.3.3 system. Maybe
I can use 8.3.3 psql to read the dumpall output.
How can I direct the output to data directory of
8.3.6 postgres?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tena Sakai
Sent: Sun 2/22/2009 1:03 AM
To: Tena
Hi,
I realized what's going, but still don't know what to do.
What's happening is that there is no pg_user table in my
new postgres, which is the problem I was going to attack
via psql. So this seems like a catch 22.
What can I do?
Tena Sakai
tsa...@gallo.ucsf.edu
-O
s
no avail. The password it is asking is not login password?
Can somebody please help?
Thank you.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
erms of postgres parameter tuning. Maybe I can
get him to say I am doing something WILD?! ;)
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Jan-Peter Seifert [mailto:jan-peter.seif...@gmx.de]
Sent: Sat 2/21/2009 5:45 AM
To: Tena Sakai; pgsql-admin@postgresql.org
Subje
day or two.
Many thanks for your help.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Sat 2/21/2009 12:57 AM
To: Uwe C. Schroeder
Cc: pgsql-admin@postgresql.org; Tena Sakai
Subject: Re: [ADMIN] very, very slow
Hi Uwe,
I can certainly add indices and run analyze on each
table and look at the performance. I am going to
upgrade to 8.3.6 (I am at 8.3.3) and then add indices.
It might take a few days before I can update you with
outcome, but I will keep you posted.
Many thanks.
Regards,
Tena Sakai
tsa
)
Total runtime: 68792886.556 ms
(10 rows)
canon=#
Can you please comment?
Many thanks.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Thu 2/19/2009 9:48 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Sub
st 13+ hours and I have no
idea how much longer it might take.
> I recommend follow this thread:
> http://archives.postgresql.org/pgsql-hackers/2009-02/msg00718.php
That's pretty interesting stuff. I need to experiment tweaking
parameters Joshua mentions. Alas, now is not a good time
red_buffers = 1024MB
temp_buffers = 128MB
max_fsm_pages = 153600
vacuum_cost_delay = 0
checkpoint_segments = 3
checkpoint_timeout = 5min
checkpoint_warning = 30s
I don't think I am doing anything wild... Am I?
Oh, one more thing, I said that there are 24 queries/jobs
happening, but there are a bunch of them that says
or in transaction --according to pg_stat_activity
view.
Can anybody suggest anything that I can do to gain speed?
Any help is much appreciated.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Hi Scott,
It's too bad (in this particular case) that you are
agreeing with me! I want someone to find a hole in
my logic so that I can find a handle to fix the
problem. The problem being that postgres doesn't get
started when the machine gets rebooted.
Regards,
Tena Sakai
[EMAIL
d reboot. But it seems in my case
nothing is turned on for level 6. Then that missing 'l'
is really of no significance?
Any thoughts? Clues?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thu 9/25/2008 12:46 PM
To
iliar to you (or you have some clue as to
what is going on), I would appreciate a tip.
Regards,
Tena Sakai
[EMAIL PROTECTED]
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ith 262144 after testing
for (int i = 0; i < 256; i++) {
System.out.print (myHex55);
}
} // end main()
} // end class
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Steve Crawford
S
Hi,
As a clueless, optimistic traveller, I'd interpret
what Scott's saying as, "maybe slightly less to
worry about."
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tue 9/23/2008 9:21 PM
To: Tena Sakai
Cc:
t won't be time consuming task.
Why not give it a wheel? It would be good to
find out one way or the other.
Scott: Are files through 002F (which are
not there) absolutely necessary for recovering data?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PRO
Hi Carol,
Unless it is impossibly difficult, I would try
to move onto the latest (8.3.4) postgres before
the situation worsens. I had followed Scott's
advice in the past and never regretted.
My two bits, again.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Ma
ostgres version I was running was 8.3.0.
The lesson I learned was to keep an eye on the
pg_clog directory. Since the installation of
8.3.3 there has been only one file (), though
the size keeps growing (I think by 8k bytes).
My two bits.
Tena Sakai
[EMAIL PROTECTED]
-Original Me
Many thanks, Scott!
Tena
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Mon 9/22/2008 11:21 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] question on pg_ctl
On Mon, Sep 22, 2008 at 11:49 AM, Tena Sakai <[EMAIL PROTECTED]> wrote
,
Tena Sakai
[EMAIL PROTECTED]
og
Wed Aug 27 09:09:04 PDT 2008
total 32
-rw--- 1 postgres postgres 32768 Aug 27 02:33
Yesterday the byte count was 24576.
Voila! 24576 + 8192 -> 32768
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Tue
ata/pg_clog
-bash-3.00$ ll
total 24
-rw--- 1 postgres postgres 24576 Aug 26 02:33
As I compare the size with what's in last night's email,
there is no difference in size. The timestamp is in the
middle of night.
Fascinating...
Regards,
Tena Sakai
[EMAIL PROTECTED]
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
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
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]
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
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
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
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
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
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
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]
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
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]
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
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
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
1 - 100 of 185 matches
Mail list logo
