Title: RE: [GENERAL] Starting postgresql on startup
'linuxconf' on Mandrake 7.1 should be able to set postgres to run at boot time as long as you set Postgresql up from an rpm. If you got to 'Control Panel' -> 'Control service activity' -> 'postgresql'. Set Startup to automatic and select th
Greetings, Tom!
At 29.03.2001, 12:52, you wrote:
TL> Alexey Borzov <[EMAIL PROTECTED]> writes:
>> The development docs state that one can use SET SEED to seed the
>> random number generator
TL> Where? I see no such claim.
Right here:
http://www.postgresql.org/devel-corner/docs/postgres/sql-se
Hello Newsgroup
I have stability problems with my Postgres 6.4 database. I am using PHP4.0.4
and get access to the db. Sometimes when about 10-20 clients are using the
website the postgres deamon shuts down and the message "no backend cache"
appears. The processor ist at 60%-80% and about 10-15 p
I am looking for information on tuning memory usage for Postgres on Linux
(2.2 kernel). In particular I have a lot of memory relative to the size
of my database and am looking to reduce latency in queries.
Searching goegle turned up a few other cases of people asking about memory
tuning, but I di
Hi, All
Where can I get a PostGreSQL 7.1 lattest beta
version with RPM installation?
JACK
Good day,
I have a problem with plpgsql, whitch is really strange for me.
I wanna create a table, with a function like this :
CREATE FUNCTION domenii(text,text,text)
RETURNS boolean
AS 'DECLARE
legi ALIAS FOR $2;
BEGIN
CREATE TABLE legi(idc serial, idp char(10), nume char(50), PRI
My RPM install didn't set pl/pgsql too... I needed to write this code :
Execute psql template1
After this, type these 2 lines :
CREATE FUNCTION plpgsql_call_handler () RETURNS opaque AS
'/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_ha
Hi,
I'm trying to set up a PostgreSQL server on our UNIX machine (HP 9000
800/F10 - HPUX 10.01)
Installation was OK, but when I try to start the postmaster I get an
error saying that libxcurses can't be found.
Any idea how to solve this? Do I need to instaal an extra fileset form
HP-UX? Whichone?
I am using PostgreSQL JDBC drive jdbc7.0-1.2.jar on Redhat Linux 6.5
with PostgreSQL 7.0.3-2
When I
ResultSet result = statement.executeQuery(sqlStatement);
int fromRow = 10;
int toRow = 20;
// my SQL statement returns few thousand rows to ResultSet
// I only want to display result.next() from
Martín Marqués writes:
> check this:
>
> On Solaris SPARC:
>
> postgres@bugs:/space/local/pgsql > ls -l data/base/
> total 15
> drwx-- 2 postgres staff1536 Mar 29 10:57 1
> drwx-- 2 postgres staff1536 Mar 29 10:10 18719
> drwx-- 2 postgres staff1536 Mar 2
Hi folks
My installation of phpPgAdmin has suddenly stopped working. I am not
very experienced in this area and have run out of ideas. Any pointers
would be much appreciated.
THE SYMPTOMS:
- To summarise, I get all the forms primed with the initial data
from the default DB, but it won't run a
hi,
I am relatively new to postgresql. Sorry if this is a rather naive
question.
I am trying to store a fixed sized c++ class into the database and
retreive it. What is the simplest (dirtiest?!) way to do it? I couldnt
find any example on the web or in the pgsql/src directories that I could
get
Dear all
Can PostgreSQL, MySQL or other database programs can allow some user to
access some specific data while other data is prohibited to them in a
same database? If so, how to implement that? For instance, a client can
print last month's statement through the Internet by providing a
password
Hi Tom,
Ref : Thursday, March 29, 2001 1:41:49 AM
TL> Your trigger will obviously fail to generate unique keys if two
TL> transactions are running concurrently, since any two transactions
TL> started in the same minute will generate the same initial key,
TL> and if they are running concurrently
Upgrade to 7.1 as soon as it's out (shouldn't be long now)..
I successfully migrated a 6.4 database to a 7.1 database while 7.1 was in
the early beta stages, a few minor problems but the entire process only took
half an hour to complete..
Good luck!
-Mitch
Software development :
You can have it
Hi folks
My installation of phpPgAdmin has suddenly stopped working. I am not
very experienced in this area and have run out of ideas. Any pointers
would be much appreciated.
THE SYMPTOMS:
- To summarise, I get all the forms primed with the initial data
from the default DB, but it won't run a
CREATE TEMPORARY TABLE table (...
Where is the table created? On HD (what dir), in memory,...
Thanks,
Mihai Gheorghiu
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
If you could post the schema of your tables that you do the query against
and an EXPLAIN of the queries you're doing, perhaps we could further tune
your queries in addition to beefing up the memory usage of the backend..
Check this link out too.
http://postgresql.readysetnet.com/devel-corner/docs
I have a short table (10 records) with a primary key column.
What primary key column data type will make search faster: int2 or char?
What about char(n) n=2,3...?
I'm looking for speed, as that search is very frequent.
Thanks,
Mihai Gheorghiu
---(end of broadcast)-
On Friday, March, 2001-03-30 at 13:13:56, Jack wrote:
> Hi, All
>
> Where can I get a PostGreSQL 7.1 lattest beta version with RPM installation?
maybe ftp://ftp.postgresql.org/pub/dev/test-rpms/
I don't know, I've never tried them (using RH I prefer own compilation).
regards
--
Marek Pętlick
Title: RE: [GENERAL] PostGreSql 7.1
http://www.postgresql.org/sites.html has a list of mirrors try one of them near you and the RPMs should be in directory dev/test-rpms
Regards
Ben
> -Original Message-
> From: Jack [mailto:[EMAIL PROTECTED]]
> Sent: 30 March 2001 04:14
> To: [EM
[ Charset ISO-8859-1 unsupported, converting... ]
> CREATE TEMPORARY TABLE table (...
> Where is the table created? On HD (what dir), in memory,...
On disk, deleted when session exits.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610
Hi,
I had the following problem: I have a table with around 5Mio entries.
I joined this table with a table with about 50 entries. Doing a insert into
another_table . I am sure the select-statement might be
optimized but after 6 days of running I had to reboot the machine for other
reasons. The Ma
Hi,
Peter, is that new? I have used SetLogStream with your 7.1 beta 5 driver and
7.03 Postgress but didn't see any output from queries that I didn't put there?
Or could it have to do with my server config that I didn't see anything? I
mean no query info, I did see info on the driver and on the c
In my experience, the best way to find out answers like this is to try it
out and see. Usually I find that I need to fiddle around with the syntax a
bit (I believe it's called debugging) before getting something to work.
Postgresql is very powerful; the capability to utilize that power comes at a
At 11:30 AM 3/30/2001 -0600, you wrote:
>In my experience, the best way to find out answers like this is to try it
>out and see. Usually I find that I need to fiddle around with the syntax a
>bit (I believe it's called debugging) before getting something to work.
>Postgresql is very powerful; the
Mihai Gheorghiu wrote:
> I have a short table (10 records) with a primary key column.
>
> What primary key column data type will make search faster: int2 or char?
> What about char(n) n=2,3...?
> I'm looking for speed, as that search is very frequent.
With such a short table, won't a in
I am new to the mailing list, but not new to postgres. I did search through
the mail-list archives, and didn't find an answer to this question. Oracle
has a concept of a "globally unique ID" which can be gotten from their
function call SYS_GUID(). Is there any plan to implement this (or somethi
On Fri, Mar 30, 2001 at 10:18:56AM -0500,
Mitch Vincent <[EMAIL PROTECTED]> wrote:
> If you could post the schema of your tables that you do the query against
> and an EXPLAIN of the queries you're doing, perhaps we could further tune
> your queries in addition to beefing up the memory usage of
On Fri, Mar 30, 2001 at 10:57:42AM -0800, Soma Interesting wrote:
> In the following, is there something I can do so that postgres will
> evaluate NEW.qty to NEW.name, treating qty as a variable and evaluating it
> before evaluating the field reference? At this time it errors on an INSERT
> wit
On Thu, Mar 29, 2001 at 06:05:04PM -0800, Eric G. Miller wrote:
> On Thu, Mar 29, 2001 at 01:17:29PM -0600, will trillich wrote:
> > is this kind of thing possible---?
> >
> > select gpa(student) from student where id=7121;
> > select gpa(course) from course where id=29931;
> > select
At 05:47 PM 3/30/2001 -0600, you wrote:
>HOWEVER -- we do have arrays, don't forget... sometimes they can
>be bent to do more than intended (but usually not!)
>
> create table mailing(
> person_id serial,
> sent int4[],
> prefs varchar[],
>
On Fri, Mar 30, 2001 at 12:27:39AM -0500, Gregory Wood wrote:
> > SELECT sum(grade) / count(grade) As GPA FROM grades;
> > (bad juju if 0)
>
> No kidding... that kid totally failed ALL his classes! And before someone
> points it out, yes I saw the DBZ.
dbz?
--
does a
On Fri, Mar 30, 2001 at 04:39:21PM -0800, Soma Interesting wrote:
> At 05:47 PM 3/30/2001 -0600, you wrote:
> >HOWEVER -- we do have arrays, don't forget... sometimes they can
> >be bent to do more than intended (but usually not!)
> >
> > create table mailing(
> > person_id
Alexey Borzov <[EMAIL PROTECTED]> writes:
> I believe the whole matter was clarified enough, so now you seem to
> have two options: either change everything back, or update the docs
> (add BIG BOLD letters that SET SEED is now obsolete) ;]
We changed it back, so the docs are still okay ;-)
At 06:47 PM 3/30/2001 -0600, you wrote:
> > I may be able to use array's if postgres will allow using variables to
> > reference points in the array.
OK, so how do I reference a specific element of an array in a record within
pl/pgsql.
I've tried:
NEW.name[1]
NEW.name.1
On Wed, Mar 28, 2001 at 07:41:36PM -0500, Swaminathan Natarajan wrote:
> hi,
>
> I am relatively new to postgresql. Sorry if this is a rather naive
> question.
>
> I am trying to store a fixed sized c++ class into the database and
> retreive it. What is the simplest (dirtiest?!) way to do it? I
On Fri, Mar 30, 2001 at 06:40:13PM -0600, will trillich wrote:
> > I'm not sure why you have a separate column for each grade... Probably
> > missing something...
>
> also want to keep statistics on /how many/ F's, A's, etc.
> one F, one A give the same GPA as two C's.
I see.
> select * f
On Fri, Mar 30, 2001 at 06:49:51PM -0600, will trillich wrote:
> On Fri, Mar 30, 2001 at 12:27:39AM -0500, Gregory Wood wrote:
> > > SELECT sum(grade) / count(grade) As GPA FROM grades;
> > > (bad juju if 0)
> >
> > No kidding... that kid totally failed ALL his classes! A
On Thu, Mar 29, 2001 at 02:38:31PM -0800, Soma Interesting wrote:
>
> I want to be able to reference NEW.field_0 though NEW.field_x where x is
> coming from NEW.qty in a FOR loop of pl/pgsql function. Is this possible?
>
> In other words:
>
> FOR j IN 0..NEW.str LOOP
>
Alexey Rodriguez Yakushev <[EMAIL PROTECTED]> writes:
> Let me rephrase the question, i have a web-based application which uses
> postgres as its backend. It must be operating 24 hours 7 days. If i want to
> make a backup of the database using pg_dump, wouldn't it be possible that a
> transacti
Soma Interesting <[EMAIL PROTECTED]> writes:
> In the following, is there something I can do so that postgres will
> evaluate NEW.qty to NEW.name, treating qty as a variable and evaluating it
> before evaluating the field reference?
Plain PLSQL will not do this --- it wants to know field names
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
> is there a way to tell the postmaster to listen to a specific ip-address
> on a multihomed host?
Not in 7.0, but 7.1 has a postmaster command line switch for this.
regards, tom lane
---(end of bro
On Sat, Mar 31, 2001 at 12:42:29AM -0500, Tom Lane wrote:
> Soma Interesting <[EMAIL PROTECTED]> writes:
> > In the following, is there something I can do so that postgres will
> > evaluate NEW.qty to NEW.name, treating qty as a variable and evaluating it
> > before evaluating the field referenc
On Fri, Mar 30, 2001 at 06:02:27PM -0800, Soma Interesting wrote:
> At 06:47 PM 3/30/2001 -0600, you wrote:
> > > I may be able to use array's if postgres will allow using variables to
> > > reference points in the array.
>
>
> OK, so how do I reference a specific element of an array in a record
On Fri, Mar 30, 2001 at 06:34:45PM -0800, Eric G. Miller wrote:
> On Fri, Mar 30, 2001 at 06:40:13PM -0600, will trillich wrote:
> > even using PLPGSQL, is it possible to send VARYING relation
> > tuples to a procedure/function -- so long as the attributes
> > (fields) munged within the function a
Jim Mercer wrote:
>
>i seem to recall setting this up before, but now i can't seem to
>get passwords working the way i want.
>
>i'm running 7.0.3 on FreeBSD 4.3-RC.
>
>i've set the entry in pg_hba.conf to both "crypt" and "password".
>
>i've used "ALTER USER pgsql WITH PASSWORD '
47 matches
Mail list logo