Hi folks,
despite the fact that postmaster is running, the
Sequential Regression Test claims it isn't and thus does not test anything. I
don't know (still rookie) whether this has anything to do with the Test-problem,
but I can't start postmaster according to the installation guide. The Pa
Using psql I have had this error appearing in the
last 2 days
that has not before,
we are using postgres 6.2 on Redhat linux
6.2
NOTICE: Message from PostgreSQL
backend: The Postmaster has
informed me that some other backend died abnormally and possibly corrupted
shared memory.
as user postgres simply do the following:
createuser username
that will promt you for a couple of questions, asking if you want that user
to beable to make databases and to add users.
Mike
- Original Message -
From: "Anatoly K. Lasareff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[
Dear Sir,
Thanks for your precious advice now things have
started working but now we are facing other problem.
When we give the command "nmblookup -d 2 '*' it shows
IP address of some of the computers in the network and
not all and also when we check in network
neighbourhood of other compute
Be sure to stop postgres, rotate your log (or move it out of the /var/log
directory and then rotate it), and restart postgresql. That will solve your
problem. Hopefully you don't need a 24x7 available database as this might take
a few seconds for your server to complete.
On Wed, 07 Mar 2001, Wi
Hi
We are experiencing this scenario -
1. at the point postgresql (postmaster) is stopped and restarted the disk
usage is 56% (277336 blocks)
2. after about 2 days the disk usage is 69% (339528 blocks)... after about
1 week it goes up to 100%
3. after stopping and restarting postgresql (postmas
Hi all,
I am witnessing something strange with my timestamps here and I am
desperately hoping someone can explain or assist.
If I set a time using unix timestamp, it is recalled as a different time
a week different!
The following example is for illustration purposes:
pulver=# select version();
> If I modify function A (drop && re_create), then I have to re_create
> function B though no change to function B.
>
> Is there any way (sql stmt) let me re_load function B's defination
> without using drop and create??
i have not figured out a way to do anything like this. an additional
frust
There is another (almost fully) DBI compliant Python module, and Z database adapter,
here:
http://initd.org/Software/psycopg/
I haven't tried it myself, merely passing along the info. Anyone know whether or not
someone is working on Python as a server-side function language (PL/Python)?
--
Ric
Hi everyone, and thanks a lot ,
> PostgreSQL access permissions are not yet as extensive as the full SQL
> spec requires.
> 'w' includes UPDATE and DELETE;
> there is no finer-grained permission available.
if i do on (PostgreSQL 7.1beta4 ) :
GRANT UPDATE ON tabl TO user;
user c
On Wed, 7 Mar 2001, Sean Weissensee wrote:
> Using psql I have had this error appearing in the last 2 days
> that has not before,
>
> we are using postgres 6.2 on Redhat linux 6.2
>
> NOTICE: Message from PostgreSQL backend:
> The Postmaster has informed me that some other backend died
I get the followig error although TK is installed
-start
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgaccess'
make[2]: Entering directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh'
gcc -I../../include -I../../backe
Servus Christian!
At 22:07 2001-03-12 +0100, Christian Marschalek wrote:
>I get the followig error although TK is installed
Are you sure, yout TK-includes, libs are available to the compiler? Ever tried to
compile a simple Tk program yourself? (I've never written Tk, so I cannot give you a
"He
I read on a website dedicated to MySQL, that the limit clause allows
someone to restrict the result of a query to a certain domain.
Exemple : "select id, title from movie order by id limit 3" -> only the
(here, first) 3 lines of the table
I did knew about this, but the author goes further about th
IIRC, the postgres syntax uses limit and offset for what rows to get
(ie LIMIT 1 OFFSET 10)
On Mon, 12 Mar 2001, Richard Bayet wrote:
> I read on a website dedicated to MySQL, that the limit clause allows
> someone to restrict the result of a query to a certain domain.
> Exemple : "select id, t
Marc Wrubleski <[EMAIL PROTECTED]> writes:
> pulver=# update connections set starttime = timestamp 'epoch' + reltime
> '984685319';
That calculation does not do what you seem to think it does. (Hint:
reltime is not simply a number of seconds.)
Try just timestamp(984685319) instead.
Hello,
I'm sure this has been covered before, but the ML archive search engine is
down (?!).
After telling postgresql not to trust anyone, but always use password/crypt
as the authenticaton method (pg_hdb.conf), I can't seem to get the
postmaster to authenticate against the right password.
What
ALTER USER postgres WITH PASSWORD 'yourpassword';
On Mon, 12 Mar 2001, Peter Schuller wrote:
> Hello,
>
> I'm sure this has been covered before, but the ML archive search engine is
> down (?!).
>
> After telling postgresql not to trust anyone, but always use password/crypt
> as the authenticat
Richard Bayet <[EMAIL PROTECTED]> writes:
> I did knew about this, but the author goes further about the "limit
> N,P", which allows someone to get only results between the Nth and Pth
> lines of the whole result...
Is that actually how MySQL interprets two parameters? We treat them
as count and
If you want to see your linux box in network neighbourhood, you have to
run samba on the linux box!
See: http://www.samba.org
regards,
Dave
Silky Mittal wrote:
>
> Dear Sir,
> Thanks for your precious advice now things have
> started working but now we are facing other problem.
> When w
I believe the only thing you can do is revoke the INSERT permission (after
granting UPDATE), but I don think you can revoke the DELETE permission
since is the same flag as UPDATE.
hicham bouzdad wrote:
> Hi everyone, and thanks a lot ,
>
> > PostgreSQL access permissions are not yet as extensi
Even more strange to me is this one below:
pulver=# select date_part('epoch', timestamp 'epoch' + reltime '98529111
seconds');
date_part
---
98701911
(1 row)
>
>
>
>
>
> Subject: Strange behavior with timestamps
Tom Lane a écrit :
>
> Richard Bayet <[EMAIL PROTECTED]> writes:
> > I did knew about this, but the author goes further about the "limit
> > N,P", which allows someone to get only results between the Nth and Pth
> > lines of the whole result...
>
> Is that actually how MySQL interprets two param
Hello all -
My users are able to connect to a main database and then create their own
databases.
However I do not want them to be able to create tables in the main database.
But in the main database, some users always create tables, which I have to
periodically go in and drop.
I have tried to de
Hi,
Lets say I had a scenario, where a user A owns a
number of tables
Now A, only wants to allow access to those tables (
updates/ inserts) via
a specific interface that is setup as functions
owned by A
How would you give permission to other users to
make use of these funtions,
such th
On Wed, Mar 07, 2001 at 01:27:07PM -0800, Rick Robino wrote:
> There is another (almost fully) DBI compliant Python module, and Z database adapter,
> here:
>
> http://initd.org/Software/psycopg/
>
> I haven't tried it myself, merely passing along the info. Anyone know whether or not
> someone i
Unfortunately There is no way atleast i do not know of
such since you can not REVOKE this from users. I do
not know why The developers consider this as not so
inportant. This capability was in the todo list for
7.1 but was removed. I would like to see this feature
in postgres because I'm tyred dro
27 matches
Mail list logo
