Re: [ADMIN] getting service from a local server (v8.2.4)

"Tena Sakai" <[EMAIL PROTECTED]> writes: > I installed postgres v 8.2.4 on a new linux server (not upgrade, > but a virgin install) and created a couple of users. For the > sake of clarity and concreteness, I will call this server S824. > There is another server on the network where S824 resides t

Re: [ADMIN] getting service from a local server (v8.2.4)

From: "Tena Sakai" <[EMAIL PROTECTED]> To: Subject: [ADMIN] getting service from a local server (v8.2.4) Date: Wed, 18 Jul 2007 21:13:11 -0700 Hi, I am new to postgres and having a strange problem. Please help. I installed postgres v 8.2.4 on a new linux server (not upgrade, but a virgin

[ADMIN] getting service from a local server (v8.2.4)

Hi, I am new to postgres and having a strange problem. Please help. I installed postgres v 8.2.4 on a new linux server (not upgrade, but a virgin install) and created a couple of users. For the sake of clarity and concreteness, I will call this server S824. There is another server on the networ

[ADMIN] pgmemcache

As anyone used pgmemcache? I would like to look more into a but I'm having problems installing the sql. I'm on OS X 10.4 and the sql there are lines causing errors: (e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;) thanks for any input and also will version 1.2 come

Re: [ADMIN] What user privileges do I need to CREATE FUNCTION's?

Please disregard my last post about creating a schema. I found the answer. You have to be connected to a database to create a schema in that database. km4hr wrote: > > Thanks Milen. Assigning superuser role worked. > > Speaking of schema's, I logged in as user "postgres" and created a schema

Re: [ADMIN] What user privileges do I need to CREATE FUNCTION's?

Thanks Milen. Assigning superuser role worked. Speaking of schema's, I logged in as user "postgres" and created a schema called "schema1" as follows: CREATE SCHEMA schema1 AUTHORIZATION newuser; I then typed "\dn" and saw "schema1" in the list. I then logged in as "newuser" and typed "\dn". "s

Re: [ADMIN] syslog: log line length?

Michael Monnerie wrote: > On Freitag, 29. Juni 2007 Michael Monnerie wrote: > > I have most entries split over several lines: > > > > Jun 29 19:56:40 db.xxx.xxx postgres[10640]: [5-1] DB=XXX U=XXX > > H=1.1.1.1 16854186.2190 idleLOG: Verbindungsende: Sitzungszeit: > > 0:01:22.10 Jun 29 19:56:40 db

Re: [ADMIN] Setting usesuper bit for user postgres.

John Horvath <[EMAIL PROTECTED]> writes: > The 'usesuper' bit for user "postgres" was set to 'f' by default in the > pg_shadow table in my > PostgreSQL 7.4.2 installation when I installed it on my OS X host. I seriously, seriously doubt that there was no superuser by default. > Any pointers on h

Re: [ADMIN] am i creating a performance bottleneck?

On 17.07-17:31, Mary Anderson wrote: [ ... ] > I am most worried about the second select, with its 'NOT EXISTS' > statement slowing everything down. I would put appropriate indexes on > this -- namely an index on series for data and an index on dhd for > da_id. My user community is a bunch of

[ADMIN] Setting usesuper bit for user postgres.

Greetings. I have trawled the Web for answers but have found none to my problem. The 'usesuper' bit for user "postgres" was set to 'f' by default in the pg_shadow table in my PostgreSQL 7.4.2 installation when I installed it on my OS X host. My database is working fine (has been for a couple

[ADMIN] "CREATE TABLESPACE" cannot run within a Stored Procedure - "Inside a transaction bloc"

Hi, Is there a way to run CREATE TABLESOACE,DATABASE etc. winthin a stored procedure? Thanks Danny

Re: [ADMIN] syslog: log line length?

On Freitag, 29. Juni 2007 Michael Monnerie wrote: > I have most entries split over several lines: > > Jun 29 19:56:40 db.xxx.xxx postgres[10640]: [5-1] DB=XXX U=XXX > H=1.1.1.1 16854186.2190 idleLOG: Verbindungsende: Sitzungszeit: > 0:01:22.10 Jun 29 19:56:40 db.xxx.xxx postgres[10640]: [5-2] > B