set digest
I 'm triyng to use JDBC driver with PostgreSQL, but I don't see the Indexes
of the tables.
Why ?
Hi,
Brett and Ron said to me to rebuild php with the --with-pgsql option
in the configuration step.
I've already did what you recommend but another warning is appearing!
Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
user 'password=' is not in 'pg_shadow' in
The last thing that a system admin needs when upgrading PostgreSQL is "Oh,
crap, I forgot to uninstall the RPM of the old one first."
If you're switching from RPM to compiling source, that's your own damn
fault. If you're upgrading (rpm -U) then that isn't a concern, as it does it
for you.
On Thu, Oct 26, 2000 at 10:14:13AM -0200, danyele wrote:
Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
user 'password=' is not in 'pg_shadow' in lib.inc.php on line 121
Error - /www/servers/phpPgAdmin/index.php
Yes. You've passed the username and password incorrectly
No, I'm sorry, but there is no core file.
You're probably running one of those setups where the postmaster is
started with a ulimit setting that prevents core dumps. You might
want to look into changing that for future debugging purposes.
Yes, you are right, I changed it in /etc/profile.
set digest
The problem is that you can't share the same port for different instance of
postmaster.
Start postmaster with the option -p can help. so,
$ nohup postmaster -i -p 5432 -D /home/user/database
$ nohup postmaster -i -p 5433 -D /home/user1/database
$ nohup postmaster -i -p 5434 -D
The last thing that a system admin needs when upgrading PostgreSQL is
"Oh,
crap, I forgot to uninstall the RPM of the old one first."
Then upgrade the RPM's. It isn't hard.
OK, here's a situation. One of the programmers at your company runs the
disk out of space. You're going to go
How can I modify pgsql source to remove case-sensitive for query like this
one :
select "ARG1" from "TABLE1"
select "arg1" from "table1"
referer to the same table's name and argument's name ?
You must use initlocation to initialize the location and have the path to the
location in an environment variable before postmaster is started.
For example:
setenv PGDATA2 /home/someuser/data
initlocation 'PGDATA2'
pg_ctl -D /home/pgsql/data start
createdb mydb -D 'PGDATA2'
This will start
On Thu, 26 Oct 2000, danyele wrote:
Brett and Ron said to me to rebuild php with the --with-pgsql option
in the configuration step.
I've already did what you recommend but another warning is appearing!
Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
user
Which version of the driver are you using?
There's a problem with DatabaseMetadata.getTables(). As I'm rewriting all
the queries in that class on Saturday, this should dissapear in 7.1.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROTECTED]
WWW:
The Hermit Hacker [EMAIL PROTECTED] writes:
On Wed, 25 Oct 2000, Holger Klawitter wrote:
Pawel Wegrzyn wrote:
Hi,
What is the latest version of PostgreSQL?
Is there something like 7.1?
The most recent version 7.0.2. 7.1 is about to come - I am looking
forward to it as
-Original Message-
From: Frank Miles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] newbie debugging pl/pgsql : better way?
I have a simple function that isn't working. I've enabled debugging,
but the error message is still
Hmm so, if the local administrator wants to compile the source, it
should go in /usr/local. If he wants to use a package manager, it should go
somewhere else? Seems either pedantic or silly to me.
Perhaps, but such is how the FHS came out. FWIW, SCO (what I work on daily)
seems to
To all,
I can't figure out how to provide access controls to individual
database files/regulate 'user's access to adding tables, etc... The
documentation says 'Someone needs to write this section.' Help!!!
-Robert
-Original Message-
From: Dominic J. Eidson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 5:10 PM
To: Robert Kernell
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] three things
On Tue, 24 Oct 2000, Robert Kernell wrote:
1.) Can someone point me to the Postgres User's
From root Thu Oct 26 14:44:32 2000
Received: from storage.network.com (storage.network.com [129.191.1.4])
by anubis.network.com (8.9.3/8.9.3) with ESMTP id OAA05733
for [EMAIL PROTECTED]; Thu, 26 Oct 2000 14:44:29 -0500 (CDT)
Received: from bush.rutgersinsurance.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 9:48 AM
To: danyele
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] phpPgAdmin
On Tue, 24 Oct 2000, danyele wrote:
I'm trying to use phpPgAdmin, but it's showing a error like"
On Thu, Oct 26, 2000 at 10:14:13AM -0200, danyele wrote:
Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
user 'password=' is not in 'pg_shadow' in lib.inc.php on line 121
Error - /www/servers/phpPgAdmin/index.php
What is on line 121 in lib.inc.php?
It seems you haven't
-Original Message-
From: Brook Milligan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 4:05 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] index problems
I am getting the following messages when I VACUUM ANALYZE:
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF
Hello,
upon making a call to ResultSet.getBigDecimal(String column_name) I get an
SQLException with the following message:
This method is not yet implemented.
Can this be ? getBigDecimal() is vital to most JDBC applications because it
is widely used as the primary key datatype.
I use the JDBC
Steve Wolfe wrote:
Then upgrade the RPM's. It isn't hard.
OK, here's a situation. One of the programmers at your company runs the
disk out of space. You're going to go bonk him on the head, but first,
there are more pressing matters. PostgreSQL 6.5 has horked up the tables,
and
Did massive amounts
of searching and read Tom Lane's post regarding the subject, but that was dated
January of 1999. Was wondering if anyone know if there was any progress on
the issue and what the resulting outcome was.
Is there a way to
select distinct on one column and sort by another?
Bruce Momjian wrote:
Trond Eivind Glomsrød wrote:
How compatible with 7.0 and 7.1 be from an application standpoint?
Will applications linked with libraries from 7.0 be able to talk to
the 7.1 database? Any changes in library major versions? The other
way?
Historically, all
Oops, sorry!
David
[EMAIL PROTECTED] writes:
This is a multi-part message in MIME format...
=_972603822-62422-5
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Description: Index
Mime-Version: 1.0
X-Mailer: MIME-tools 5.316 (Entity 5.212)
PostgreSQL
28 matches
Mail list logo