>> Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
>> is not in 'pg_shadow'
Some kind of syntactic confusion at the client end, evidently: the
software is taking "password=" as your username, which I'm pretty
sure is not what you intended.
reg
Anatole Varin wrote:
>
> Hi,
> Thanks for your advice. I set my password as you advised below, however I'm
> still having some problems connecting. When I try to connect I get the
> following error message:
>
> Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
> is not
Hi,
Thanks for your advice. I set my password as you advised below, however I'm
still having some problems connecting. When I try to connect I get the
following error message:
Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
is not in 'pg_shadow'
When connecting I'm u
In article <033f01c0de0d$ce93fcc0$230470d1@INSPIRON>, "Dave Cramer"
<[EMAIL PROTECTED]> wrote:
> http://www.zdnet.com/zdnn/stories/news/0,4586,2760874,00.html?chkpt=zdnn0516
> 01
>
> It would be great if we could see where postgres fits in this benchmark
There are lies, damned lies, and benchma
Buenas tardes, all.
I'm puzzled by my inability to use the following INSERT statement:
INSERT INTO RM_USER VALUES(RM_USER.ID, RM_USER.FIRST_NAME) VALUES(1, 'DUBYA')
it seems that postgres is unhappy about the explicit column naming
(e.g. 'RM_USER.ID' instead of just 'ID') because I end up with
This is a guess - have you tried:
SELECT * FROM tableName WHERE time = CURRENT_TIMESTAMP - '3
months'::interval
let me know if it works!
-r
At 05:49 PM 5/15/01 +0900, hiroko wrote:
hi all.
from a DB table, I'd like to SELECT out the date of 3months
before.
the command should be
=> select
Jeff Patterson <[EMAIL PROTECTED]> writes:
> I recently upgraded from 7.0.3 to 7.1. Everything went fine until I went to
> install plperl using createlang. It throws the following error message:
> ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed:
>/usr/lib/perl5/5.6.0/i686-linux/auto/
I recently upgraded from 7.0.3 to 7.1. Everything went fine until I went to
install plperl using createlang. It throws the following error message:
ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed:
/usr/lib/perl5/5.6.0/i686-linux/auto/Opcode/Opcode.so: undefined symbol: Perl_save_vptr
Hi,
You could use the following...;-)
psql -U postgres template1
UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres';
You could also use GRANT or create other users as well... kindly check
the administrative section of your documentation...;-)
Cheers,
John Clark
Hi,
I'm new to this list and Postgres. I have Postgres up and running, but I'm
having trouble understanding the password system. In particular, I have the
following troubles:
1. Is it correct that users can only be given permissions on a particular
TABLE?
2. The owner of all my tables are listed a
I'm having trouble setting up a remote Apache PHP webserver to connect to
our postgres machine using ODBC.
This is what I get when trying to connect with the odbc_connect statement:
Warning: SQL error: Missing server name, port, or database name in call to
CC_connect., SQL state IM002 in SQLCo
User JOHN <[EMAIL PROTECTED]> writes:
> But when i try to run any of the perl scripts designed for the database
> I'm getting the following error:
> Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-fr
> calendar=# explain select * from schedule where schedule.owner_id in
> (select group_id from groups where user_id=101);
> NOTICE: QUERY PLAN:
> Seq Scan on schedule (cost=0.00..2039895.00 rows=100 width=40)
> SubPlan
> -> Materialize (cost=2.02..2.02 rows=1 width=4)
> ->
I'm stress testing my application by creating large data sets. This
particular query selects rows from the schedule table that have a specific
owner_id. (I'll show you the results of explain)
calendar=# explain select * from schedule where schedule.owner_id=101 or
schedule.owner_id=102;
Index S
> Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> /usr/local/lib/perl5/site_perl/5.005 .) at ./top25.pl line 2.
>
> Line 2 of the specific program reads:Use Pg;
Make sure that the user
Trygve Falch wrote:
>
> In article <[EMAIL PROTECTED]>, "Nils Zonneveld" <[EMAIL PROTECTED]>
> wrote:
>
> >> Actually I think I found 'Allow queries across multiple databases' in
> >> the TODO-list under something they call 'Exotic feature'. I thought
> >> that this feature was relativly basic
Help me, please.
Can I create a 2 Parallel Server with clustrering DB PostgreSQL?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Hello there,
I have a FreeBSD machine that died earlier this week and i have been
attempting to restore it (or rather it's contents). Postgres has caused
somewhat of a problem in this area.
I was running 7.0.1 and decided to upgrade to 7.0.3 since i have to
reinstall it anyways. The install
Is it possible to use NULL indicator variable for ESQL?
If it is, please tell me how to declare the indicator and use..
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Hi,
If I have the WAL pointing to a different disk that the main postgres
database, and that other disk crashes (say writing to it blocks) what will
postgres do ? Will it continue to write OK to the main database, or will the
whole thing crash ? or hang waiting for the WAL writes to finish ?
T
hi all.
from a DB table, I'd like to SELECT out the date of 3months
before.
the command should be
=> select * from MYTBL where time =XX ;
what whould it like to be at X ?
I thought that I can use the type of 'today', which is meant
to be the 0:00am of the day.
or 'current' or thi
Hi,
This sort of post is giving open source software a bad name.
I am glad that this post has only reached a small number of people who
are already pro-PostgreSQL and has not reached the crowd who needs
convincing that their time, attention, enthusiasm, and money is better
spent on PostgreSQL th
On Tuesday 15 May 2001 14:40, you wrote:
> Hello,
>
> I have 2 tables :
>
> CREATE TABLE e_kalkn (
> idINT4 NOT NULL,
> roba VARCHAR(6) NOT NULL,
> dat DATENOT NU
23 matches
Mail list logo
