Hi to All,
Can anyone tell me how to create
useable postgres user ID?
Problem
I create the postgres user ID
through postgres's CREATEUSER command. After the creation, I try to
use psql -U to login this user ID to
postgresql database server. But the server refuse the ID with s
On Tuesday, January 15, 2002, at 03:24 PM, Andy Gussie wrote:
How do I get off this mailing list?
You should have received an email like this when you subscribed:
From: [EMAIL PROTECTED]
Date: Tue Jul 03, 2001 10:31:54 AM Australia/Sydney
To: [EMAIL PROTECTED]
Subject: Welcome to the pgsql-
How do I get off this mailing list?
--
Andy Gussie
Network Administrator eFruit International, Inc. http://www.efruitinternational.com
President VI Massive, Inc. http://www.vimassive.net
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
Hello everybody.
Is there any way to check database status, or who is currently connected to it.
I tried to drop database and got an error saying that other users using this database.
So I wanted to see who is connected right now
It looks like the user you are when you install postgres does not know the
path to your compiler. Try installing gcc and use it instead of cc to
compile postgres. Make sure your user's .profile has the path to gcc before
installing.
Heather
- Original Message -
From: "Allan C. Huffman" <
On Mon, 14 Jan 2002 18:11:59 +0100
"Allan C. Huffman" <[EMAIL PROTECTED]> wrote:
> Hello Everyone,
>
> It has been sometime since I have installed PostgreSQL. It has been
> running great with no crashes for like a year! But alas, my faithful
> Sparc 20 turned belly-up. It is sad to loose an o
I did have this problem in the past. I have a table with three fields
set for the primary key. Somehow I would get dups in that table. I'm
not sure how as I am too busy to test it. I changed my insert queries
to check for existing data before the insert so I could get back to
work.
Someone di
> I want to add replication capabilities to my postgresql installation. Can
> anyone recommend a good way (open source or otherwise) to do so?
>
> Basically, I have a web tracking application that must quickly and
reliably
> store massive amounts of tracking data. Later, I run complex queries to
>
Hi All,
Our application needs to do a moderate level of inserts into
the database as it runs. We can hit 100-200 inserts a second
under certain conditions - and it is not something we can batch up for
later processing. While testing out postgres I noticed
some trobling performance data under t
Hello everybody.
Is there any way to check database status, or who is currently connected
to it.
I tried to drop database and got an error saying that other users using
this database.
So I wanted to see who is connected right now to the database.
One more question is how can I see all tables in t
Hello Everyone,
It has been sometime since I have installed PostgreSQL. It has been
running great with no crashes for like a year! But alas, my faithful
Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@
I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk
t
Greetings,
Is there support for Greek characters using ISO-8859-7 in the latest
production version of Postgres, v7.1.3?
I can see that it is possible to use
./configure --enable-multibyte[=encoding_system] --enable-locale
but the list of available encodings does not seem to include ISO-8859-
help me please, I am using Postgresql, I want to know
if exists a limit in the number of rows to create a
function. I created a function using pgaccess, but
when I try to see it using PgAdmin, I can not see all
the lines I wrote. Thank you for your answers. I am
writting from Colombia (I am still
Hi all
My problem is, my filesystem is full and I can't extend it, so can i use a
secondary filesystem ?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
On Fri, 11 Jan 2002 17:39:06 +0900, Yasuo Ohgaki
<[EMAIL PROTECTED]> wrote:
>Jules Alberts wrote:
>
>> On 10 Jan 2002 17:37:25 -0800, Tony Reina <[EMAIL PROTECTED]> wrote:
>>
>>>I'm reading the list through Google groups, but I haven't seen much
>>>activity on admin, hackers, sql, etc. over the l
Dear Alls
I cannot get reasonable result for sorting on field with chinese data
Setting as follows :
linux locale : zh_TW.Big5
postgresql client and server : EUC_TW
please advise what's wrong with my setting and what should I do in order
to overcome this sorting problem.
Thanks a lot in adv
Hi all,
we use postgresql 7.2 for a data logging/supervisor application running
24 hours a day, 7 days a week and 365 (and 6 hours) a year. Data are
inserted/deleted/updated each 1,5 minutes and for performance reason we
have to vacuum each day some tables. The problem is that vacuum stops
Tony / Phil,
my 2c on the Primary Key definition / usage. If you have any SQL / DDL code
that disagrees with the definitions below could you please repost them.
"Tony Reina" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> [EMAIL PROTECTED] (Phill Kenoyer) wro
Why do you want a database where two tables have the same name? When
you do a "SELECT * from Table1" what table do you expect PostgreSQL to
use?
Now, that being said, it's possible to create temporary tables in
different connections with the same name. These tables will dissapear
when the conn
On 01/08/2002 09:17:03 PM Jason Earl wrote:
> Why do you want a database where two tables have the same name? When
> you do a "SELECT * from Table1" what table do you expect PostgreSQL to
> use?
I suspect Shamik is trying to do something like having a separate 'schema' (Oracle) for every user,
Tyson Oswald <[EMAIL PROTECTED]> writes:
> there ended up being two
> template databases, template0 and template1.
It's supposed to be that way. Leave it alone.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting
Try pointing your news reader at news.postgresql.org itself ... we just
fixed a permissions problem wiht the posts goign to the lists, so Google
and all them might get a better flow now too ...
On 11 Jan 2002, Jules Alberts wrote:
> On 10 Jan 2002 17:37:25 -0800, Tony Reina <[EMAIL PROTECTED]>
Does anyone know how I can delete a second template database without
blowing all the databses away? What happened was I was running initdb
and the user postgres didn't hvae rights to the db directory or
something and so I had to run it again, and there ended up being two
template databases, t
Hello,
I' m currently working with the PHPDOC team on maintaining and
keeping up-to-date the PHP manual. I proposed in the PHPDOC
list to include some information about database security issues.
It aims to be an introduction into the very basics of how to
access and manipulate databases within
On 10 Jan 2002 17:37:25 -0800, Tony Reina <[EMAIL PROTECTED]> wrote:
>I'm reading the list through Google groups, but I haven't seen much
>activity on admin, hackers, sql, etc. over the last few weeks. Are
>there just not any posts or is something screwy with Google groups
>newsserver?
>
>I was ho
Hello,everyone.
sorry to ask again.
I deleted one of my table using "delete * from mytable",
anyway to recover it, I searched the mail list archive last week,
there's someone ask this queston before,and someone reply with
"a python code to recover it",but I can't search the archive (the
26 matches
Mail list logo
