OH! I get it. Whereas I have the environment variables in postgres's
.bash_profile, you have it set where those variables are loaded for all
users, correct?
But the part that I don't get is that (typing it at console) I can start
postgresql (while logged in as postgres) with the command: postmas
The reason I didn't have to use the -l is that I have everything PostgreSQL
needs (as far as environment variables) already set, because this machine is
a dedicated PostgreSQL server.
Sorry, should have thought about that before I replied but it seems you have
it running now, that's great.. Good
oh... so since I did a su -l, I could have just used the command,
postmaster -i >>postgres.log 2>>1 & ? Since I had the appropriate variables
in postgres's .bash_profile?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Dale Walker" <[EMAIL PROTECT
From: "Adam Lang" <[EMAIL PROTECTED]>
To: "Alfred Perlstein" <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 4:28 PM
Subject: Re: [GENERAL] Starting postmaster at boot
> I did, and that is why I don't understand.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> ---
Adam Lang wrote:
>
> I didn't directly use your method, but you nonetheless solved my problem.
> >From the beginning everyone was telling me to put this into my rc.local:
> su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i
> /usr/local/pgsql/postgres.log 2>&1 &"
>
> It
* Adam Lang <[EMAIL PROTECTED]> [000914 13:21] wrote:
> I didn't directly use your method, but you nonetheless solved my problem.
> >From the beginning everyone was telling me to put this into my rc.local:
> su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i
> /usr/local/p
I have a machine inadvertently reboot on me this morning, and I have
been running a vacuumdb command to try and check it.
The vacuum command has processed the indexes OK, but it hasn't returned
to a prompt as yet (3hrs)
The table has only taken about 5min to do a vacuum on in the past... any
su
Also... how difficult would it be to start postgres in the rc3.d directory?
Would a file like this work? (not writing actual code since I don't know the
syntax):
Case $i
start)
su -l postgres -c "/usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data -i /usr/local/pgsql/postgres.lo
I didn't directly use your method, but you nonetheless solved my problem.
>From the beginning everyone was telling me to put this into my rc.local:
su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i
/usr/local/pgsql/postgres.log 2>&1 &"
It was never working. I noticed yo
=?iso-8859-1?Q?B=F6rkur_Sigurbj=F6rnsson?= <[EMAIL PROTECTED]> writes:
> We are seeing very strange behaviour in our OR statements:
> SELECT l.list AS list, l.locked AS usr
> FROM svr_lists_questions lq, svr_lists l
> WHERE ( l.locked != '{a7372de3-92b7-408b-8874-373b883b19a6}' )
> OR
>
hi, can anyone help me on this?
tig3prod=# update cust set agt_id = 'DEFAULT';
sorry to resend this but with the mail-list problems i haven't
seen it and don't know if anyone else has either...
ERROR: fmgr_info: Cache lookup for language failed 17533070
tig3prod=#
my guess is something's mis
At 03:31 PM 9/14/00 -0400, Adam Lang wrote:
>Does it work the same for linux?
It's basic sh, so I can only assume that it does, though I should stress
that I don't run Linux, and haven't sat at a Linux command prompt in over a
year... so I can't say it does with 100% certainty. The sh syntax
Does it work the same for linux?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "David Veatch" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>; "PGSQL General"
<[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 3:29 PM
Subject: Re: [GE
At 03:20 PM 9/14/00 -0400, Adam Lang wrote:
>I'm still having difficulties getting postgres to start on boot.
>
>Any chance someone can give me an example of how they have it on their
>system?
>
>
>(Seemed to have been lost in the list being down).
>
>Adam Lang
>Systems Engineer
>Rutger
I'm still having difficulties getting postgres to start on boot.
Any chance someone can give me an example of how they have it on their
system?
(Seemed to have been lost in the list being down).
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
"Bryan White" <[EMAIL PROTECTED]> writes:
> I found a core file. I am not all that familiar with gdb but the backtrace
> looks useless:
> #0 0x8064fb4 in ?? ()
> #1 0x809da10 in ?? ()
Looks like you are running a stripped executable :-(. You might want to
consider recompiling with debug symbo
I wouldn't recommend pg_upgrade as 6.3 is quite old, pg_dump should be a
better option.
Since you are having trouble with pg_dump also, we would probably need some
actual errors to be able to help. One suggestion is to dump everything out
with proper inserts ( use the -d or -D option for this)
We are seeing very strange behaviour in our OR statements:
> SELECT l.list AS list, l.locked AS usr
FROM svr_lists_questions lq, svr_lists l
WHERE ( l.locked != '{a7372de3-92b7-408b-8874-373b883b19a6}' )
OR ( 1=0 )
++--
> > Server process (pid 2864) exited with status 139 at Thu Sep 14 10:13:11
2000
>
> That should produce a coredump --- can you get a backtrace?
I found a core file. I am not all that familiar with gdb but the backtrace
looks useless:
#0 0x8064fb4 in ?? ()
#1 0x809da10 in ?? ()
#2 0x809e538 i
Hello,
I am trying to install the DBD module and having some problems...
-When trying to install 'DBD-Pg-0.95.tar.gz' I receive the following error
after running 'perl Makefile.PL':
"... Please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !"
-When trying to install 'DBD-Pg-0.73-
"Bryan White" <[EMAIL PROTECTED]> writes:
> Here is what a failure looks like in the log file:
>
> Server process (pid 2864) exited with status 139 at Thu Sep 14 10:13:11 2000
That should produce a coredump --- can you get a backtrace?
> I have written a small utility progra
On Thu, 14 Sep 2000, Karl Schmid wrote:
> Here is a follow-up to my previous question
>
> I just looked up the other tables in the directory
> /hdb/psql/data/base/atha_snp (atha_snp being the name of the database). The
> content of the tables in this directory reflects the state before the cra
I've got a database I would like to upgrade from 6.3.2+phpfi 2.0 to
7.0.2+php 4.0. I've found the changes needed to be made to the php code,
and that should not be a problem. The real issue I'm having at this point
is getting the data into 7.0.2, or any newer release of PostgreSQL. I've
tried th
Here is a follow up. I did a hex/ascii dump of the 3 bad tuples. In the
dump I could pick out an email address. This is an indexed field. I did a
select on each of them in the live database. The 1st and 3rd were not
found. The second worked ok if I only selected the customer id (an int4 and
could this be a servlet/thread issue? i cannot tell from the code snippet,
but remember that variables in a servlet with class scope are essentially
static. (i am guessing that query, rs, stmt, etc are all class scope. this
is very dangerous, in the programming sense of the word...) i've had
s
Apologies to anyone who has already seen this once; I sent it about
the time that many of us seemingly stopped receiving mail from the
list, so I don't know whether most people got it or not.
I've found what may be a bug in initdb, a bug in its documentation, a
misunderstanding on my part, or a c
You can get a list of all triggers in the system
as
select * from pg_trigger;
You can get the source for a PL function a trigger
calls with:
select prosrc from pg_trigger,pg_proc where
pg_proc.oid=pg_trigger.tgfoid
and pg_trigger.tgname = ''
[Note, in the case of C functions, I think this
r
I have apparently picked up a corrupt record in a table.
What happend:
Yesterday at one point the database seems to hang. There were three backend
processes consuming large amounts of CPU time. I stopped the server and
rebooted (3 months since last reboot). The database restarted and seemed to
Hello,
is there any known reason for the following behaviour:
I wrote a servlet with several database accesses via stored functions
and select statements. On a certain point of my servlet I get
the following:
[14/09/2000 16:31:51:216 CEST] Runtime.log: org.postgresql.jdbc1.ResultSet@80ab4ff
[1
just testing
sorry
begin:vcard
n:Gonzalez;Hernan
x-mozilla-html:FALSE
org:Sinectis S.A.;Depto de Sistemas (Oficina Central)
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
x-mozilla-cpt:;0
fn:Hernan Gonzalez
end:vcard
Forgive me if I am missing the obvious, but can someone please tell me how
to show a list of triggers, or the code in a specific trigger, via the pgsql
utility?
Thank you,
Bryan
Hi all,
I have a question that probably is more apropriate for pgsql-dummies but
since I use postgres and don't know what list would be more
apropriate... here goes:
I have some data that I want to be able to search by geographic location.
The geographic locations are stored in a table with a r
Me too, and I'm getting some stuff two times, like I'm double subscribed
(which I shouldn't be). Sometimes it takes few days for messages to appear
on list etc.
At 10:12 14.9.2000 , [EMAIL PROTECTED] wrote:
>I was just about to ask the same question...
>
>med vänlig hälsning
>/Dana
>
>-Origin
33 matches
Mail list logo