Hi,
Just found out what the problem was...
It appears as though i made the permissions for /tmp 700 ...;-) BIG
MISTAKE...;-)
That's what I get for being too paranoid...;-)
Cheers,
John Clark
--
/) John Clark Naldoza y Lopez (\
/ )Software Design Eng
Hi,
I recently came across a problem wherein I am not able to start my
postgreSQL 7.0.3 server.
Here's what happens..;-(
postgres@kahoy /root$ postmaster -D /var/lib/pgsql/data
FATAL: StreamServerPort: bind() failed: Permission denied
Is another postmaster already running on that port?
Sami wrote:
>
> > The insert statement executed from php is:
> > >
> > > $otsikko = "Insert testi";
> > > $teksti = "Koeteksti 1";
> > >
> > > $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
> > > $sqllause = $sqllause . $otsikko . "','" . $teksti . "');";
Hmmm...
Kyle <[EMAIL PROTECTED]> writes:
> I'm getting poor performance on 7.1 as compared to 7.0.
Hm. I don't know why 7.1 might be slower for plain SELECTs (the WAL
changes would certainly not affect that). Could you compile 7.1 for
profiling ("make clean; make PROFILE=-pg all" in the src/backend
sub
On Mon, 7 May 2001, Bruce Momjian wrote:
> I like the new mirrors web page at http://www.postgresql.org. Now I
> just need to learn about some of those flags.
The alt tags will tell you what country. Looking at the status bar
will tell you what host (if your browser supports that).
Vince.
--
Fran Fabrizio <[EMAIL PROTECTED]> writes:
> Does a view run its query every time I select from the view?
Yes. That's sort of the point.
> View definition: SELECT count(*) AS count, log.site_id, log.host_id FROM log
> WHERE (((log.status = 'CRIT'::"varchar") OR (log.status = 'EMERG'::"varchar"))
I'm getting poor performance on 7.1 as compared to 7.0. For 7.1, I'm
using the same setup as I had with 7.0. I use -F (disable fsync) and
have set postgres up with over 300MB of shared memory; that stuff
stayed consistent across the transition. I've got two 2.2 linux
machines, one setup with 7.
Thanks to all who helped me with my questions... I sometimes forget /
loose track so I'll do it this way ;)You know who you are :)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.
webb sprague <[EMAIL PROTECTED]> writes:
> Does anybody know of a good way to COPY a file into a table if the data is
> based on fixed width format?
COPY insists on having delimiters; you'll need to translate the file
format into something COPY can deal with.
> Do I just have to write some code
> takes Vince a day or two to catch up ... yes, we are officially released,
> and Tom just dump'd some major stats changes into HEAD ...
>
> On Mon, 7 May 2001, Tatsuo Ishii wrote:
>
> > Does this mean that we have officially released 7.1.1? I could not
> > find any statements regarding 7.1.1 o
Does anybody know of a good way to COPY a file into a table if the data is
based on fixed width format? Do I just have to write some code with
scanf(Ick)? For example (Sorry about the poor ASCII art formatting):
| FIELD DESCRIPTIONLENGTH POSITION|
|___
On Mon, 7 May 2001, Tulio Oliveira wrote:
> Hello, All
>
> How I prevent a new user to create new tables in a Data Base ?
>
> The Data Base is owned by "postgres" and I need that only the "postgres"
> user can create new tables ...
I don't think you can allow users to connect to a db but not c
Mihai Gheorghiu writes:
> I uncommented and made changes so that now the uncommented lines look like:
> tcpip_socket = true
> ssl = false
> max_connections = 32 # 1-1024
> port = 5432
> shared_buffers = 2*max_connections # min 16
This won't work. No arithmetic allowed.
--
Peter Eisentraut [
Mihai Gheorghiu wrote:
> /etc/rc.d/init.d/postgresql restart
> Shutsdown OK, then
> Checking postgresql installation [OK]
> Starting postgresql service [FAILED]
_I_ need to make some changes. For the time being, don't use restart.
This will be fixed for 7.1.1, which I hope to have built by this
Hello, All
How I prevent a new user to create new tables in a Data Base ?
The Data Base is owned by "postgres" and I need that only the "postgres"
user can create new tables ...
---
Where are the default messages thats appears when the Referentian
Integrity is violated ? I need change thi
Morten Primdahl <[EMAIL PROTECTED]> writes:
> I certain that I do not remove those. It happens every time
> I run the aforementioned sequence. This is postgresql 7.0.3,
> I'll upgrade to 7.1 and try again. Thanks.
Oh, I was trying 7.1. Now that I think about it, I think there's
a bug in 7.0.* th
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> This error was in 7.0.3 and is still found in 7.1. Could someone take a
> look please.
Not without a reasonably complete bug report (where are the table
schemas, for example?). Preferably a psql script to reproduce the
problem starting from an empt
>
> My inquiry:
>
> Please discuss as to your point of view the advantage of
> PostgreSQL over
> Interbase and/or vise versa. I'm considering three (3)
> important points
>
> 1. Speed
Postgresql is "spotty". Some things it can do fast other
things are very slow. It's really mixed. So P
> -Original Message-
> From: Erick Papadakis [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 05, 2001 9:13 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Re: Re: How to install on Windows?
>
>
> hi fabrice,
>
> thanks for taking the time to write that. i have indeed read
> the manu
Lieven Van Acker <[EMAIL PROTECTED]> writes:
> Are the "nested views permission problems" fixed in this release?
> If so, a dump IS necessary because of a change rule creation routines.
If you're running into that issue, you might want to drop and recreate
the affected views/rules. That's a far
I installed PostgreSQL 7.1-1 from RPM on RH7.0 (I used GNOrpm).
Then I opened a terminal and ran
/etc/rc.d/init.d/postgresql start
chkconfig --add postgresql
as per README_rpm-dist (Lamar Owen)
psql works OK, pgaccess displays an error message
(PQConnectPoll() --connect() failed... check if postma
Hello all,
I've finished upgrading to 7.1 and I'm still having trouble getting this view
to run respectably.
Does a view run its query every time I select from the view? I had been
assuming that the view recreates itself when I modify the table to which the
view is attached, but Tom mentioned t
No you can't pull directly from JDBC, but you can from ODBC
- Original Message -
From: "Tony Grant" <[EMAIL PROTECTED]>
To: "Nils Zonneveld" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 10:33 AM
Subject: Re: [GENERAL] Re: MS-Query
> On 03 May 2001 23:44:59 +020
Some additional info, I've installed Ant ver. 1.3 and Sun's Java 2 SDK
Enterprise Edition 1.2.1. JAVA_HOME is set to /usr/local/java
and /usr/local/java/bin is in the path.
Tim
- Original Message -
From: Tim Barnard
To: [EMAIL PROTECTED]
Sent: Monday, May 07, 2001 12:16 PM
Subject: A di
Thanks for the help guys.
Tim
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
"Tim Barnard" <[EMAIL PROTECTED]> writes:
> Incidently, I'm running RedHat 6.1.
See my previous message. BTW, please don't post in HTML.
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them
> 1. Speed
> 2. Data Reliability
The two above depend very much (IMHO) on SYSDBA's skills. IB and its
descendants has, probably, less options to tweak, or, more correctly, less
obvious ways to improve its performance.
OTOH, if you have strong theoretical RDBMS bacground and consider
"Tim Barnard" <[EMAIL PROTECTED]> writes:
> VFS: file-max limit 4096 reached
>
> I'm running Linux (ver. 2.2.12-20) Anyone know how to increase
> this limit?
# echo "8192" > /proc/sys/fs/file-max
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicin
I'm compiling PostgreSQL 7.1.1 with Java support
(--with-java).
During gmake, immediately after this
line:
/usr/local/ant/bin/ant -buildfile
../../../build.xml -Dmajor=7 -Dminor=1
-Dfullversion=7.1.1 -Ddef_pgport=5432
I get the following error:
/usr/local/java/bin/java: /
=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <[EMAIL PROTECTED]> writes:
>> It is said that RULES are executed with rule's owner permissions, so how
>> is it possible that different users are getting different results?
> This is not true. Rules are not executed with owner permission.
Yes they are. If
On Thu, May 03, 2001 at 11:11:20AM -0700, Terry Fielder wrote:
> Is there an autonumber data type in postgreSQL?
>
"SERIAL"
CREATE TABLE xxx (id SERIAL, data TEXT);
or see docs for 'create sequence' -- it's more controllable stuff.
Karel
--
Karel Zak <[EMAIL PROTEC
Hi,
I'm trying to install & build DBD::Pg. against Postgres7.1
I've downloaded the latest version (0.98)
Postgres was installed via the RPMs. (base, lib, delel, perl, docs, test
and server)
it's a redhat 6.2 based system but with perl 5.6 installed.
perl Makefile.PL runs OK
make runs OK,
but w
> The insert statement executed from php is:
> >
> > $otsikko = "Insert testi";
> > $teksti = "Koeteksti 1";
> >
> > $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
> > $sqllause = $sqllause . $otsikko . "','" . $teksti . "');";
>
> Have you tried without the ";"?
Not make pgsql 7.1
1.configure ---enable-multibyte=MULE_INTERNAL -with-tcl -without-tcl --with
-tclconfig=/lib
2.make
undefined reference to 'tcl_DeletefileHandler'
make[3]:**[libpgtcl.a] Error 1
make: Leaving directory '/postgresql-7.1/src/interfaces/libpgtcl'.
...
..
-
Hi,
does Postgresql 7.1 support triggers on a view actions? I've defined a few but they
doesn't seem to get fired. Problem is I cannot easily set the trigger on the tables
because of permission issues...
Lieven
---(end of broadcast)---
TIP 3:
> Try not to leave open transactions hanging around in your Apache code.
> An idle database connection couldn't block VACUUM like that; it'd have
> to have been in the middle of a BEGIN block, or maybe even an unfinished
> query.
It's possible that the JDBC library always creates a new transactio
Credits are positive, debits are negative. I have never seen an accounting
package that did not follow this basic rule.
Dave Cramer wrote:
> Hi all,
>
> Can anyone out there with more experience than me give me some hints as to
> how to do accounting tables in a db. The problem I am wrestling w
Hello,
I'm trying to create a MVS C++ 6.0 project to be able to query my
postgresql database.
I build all needed libraries (libpq.dll,libpqdll.lib,libpq.lib). All are
in release mode.
I can't succeed linking my project. I always get link errors (see
below).
Does anyone as any example of suc
Mike Mascari wrote:
>
> Can you access other data sources via MS-Query, such as local Access
> databases, or possibly remote MSSQL server databases? I can't think
> of any reason why MS-Query should be crashing...
>
I use PostgreSQL data in Word and Excel via linked tables in MS Access.
Maybe
Tom Lane wrote:
>
> Tulio Oliveira <[EMAIL PROTECTED]> writes:
> > I just lost the pg_control file, located in /usr/local/pgsql/data/global
>
> How did that happen?
>
> > I start a new INITDB after rename the PG_DATA directory to another name,
> > but if I copy the pg_control file to real data
Hi,
I recently upgraded to V7.1 version of Postgres on Linux and have noticed
that as the DB is being used, it gets progressively slower and slower, until
very simple queries slow down to a crawl. The basic setup I have is a set of
JSPs and Servlets running on Tomcat, that use Java classes
Philip Hallstrom wrote:
>
> Also... is there any reason you don't just do:
>
> SELECT MAX(id) FROM article
>
> rather than what you have below? It would get you the same thing wouldn't
> it and save a query...
>
> On Thu, 3 May 2001, Chris Ryan wrote:
>
> > Jason,
> >
> > Look into the
Hi,
triggers call their registered functions always using the parameter-less
version. For Postgres, func() and func(text) are two entirely different
things! Also, trigger functions get an implicit set of parameters, like
NEW etc. (see documentation).
IMHO, this should be done as follows:
CREAT
However Linux works better on SMP.
As I know FreeBSD still used global kernel lock (as Linux 2.2) on SMP...
"Sean Chittenden" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> --6iXXu7NwgEt9u5a7
> Content-Type: text/plain; charset=us-ascii
Hello.
I was wondering if anybody knew how to run PostgreSQL in memory. We run it
on a Alphaserver DS20 with 1 Gig Ram.
The operating system is Digital Unix ver. 4.0F. We are not to happy with the
performance. Any ideas?
Best regards
Thor Ralle
IT-manager
Billettservice as
--
Jason,
Look into the pg_result() function. You would use it something like
this:
$q = pg_Exec("SELECT id FROM article WHERE id=(SELECT MAX(id) FROM
article)");
$maxid = pg_result($q,0,0); # pg_result($result,$row,$column_num)
echo "The highest id is ". $maxid[0];
Hope this helps
Hello all, I'm having problems compiling pl/perl.
I've compiled perl 5.6.0 and 5.6.1 with and without threads and as shared (as
per the README in the perl distribution).
I've compiled postgresql both 7.0.3 and 7.1.
In all cases I get the following errors when trying to compile:
[ 11:26:33 root
> \d tbl_c_id_seq
>
> if it is not there, you can create it yourself
Thanks, the sequence was not there. Just puzzled me that
when creating tbl_c, I get:
test=# CREATE TABLE tbl_c
(id SERIAL PRIMARY KEY,
data VARCHAR(50),
a SERIAL CONSTRAINT a_ref REFERENCES tbl_a(id),
b SERIAL CONSTRAI
I am using following codes to get the accountname, and account from the
Table Account;
accountname, and account are varchar(30) and it can be null.
The code has no problem when both accountname, and account are not
null. It gives me an errror code of -209 when the account is null.
Anyone has any
>On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote:
>> Dear:
>> I wanna create a function that return a multiple rows in to a
single
>>
>> row.
>> example:
>> CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
>> TEST;' LANGUAGE 'SQL';
>>
>> when i call this function
Does someone has already work with Visual Studio C++ and postgresql ???
If yes, please do you any project configuration example ?
Thanks for help.
Armelle
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql
I'm running Mandrake 7.2 and trying to upgrade postgresql to 7.1. The
installed version has the timestamp bug, so I must upgrade. RPM install
said I needed libc.so.6, which is on my system. So I installed rpm with
--nodeps to force it to install. However, running Postgresql complains
that libc
I have 4 columns in a table, id, sub_id, timestamp and value.
The primary key is id, sub_id and timestamp combine.
I need to insert many rows (may be 10 thousands every 4 minutes)
as fast as I can to the same host, same port, same database, same table.
A.
Open only one JDBC (Java Database Conne
takes Vince a day or two to catch up ... yes, we are officially released,
and Tom just dump'd some major stats changes into HEAD ...
On Mon, 7 May 2001, Tatsuo Ishii wrote:
> Does this mean that we have officially released 7.1.1? I could not
> find any statements regarding 7.1.1 on the web pag
If your driver jdbc2.0 compliant, look at
batch processing. Choice between
one connection and many connections is not
obvious. Good driver is supposed to handle
many processes per one connection.
I would suggest starting with connection pool and 10 threads
with 10 connections doing batch update b
55 matches
Mail list logo
