Hi Jim,
so IIUC, I will have to schedule a program on the server which reads all
user information and if a new user is added it modifies the pg_hba.conf and
reloads the server?
thanks,
-- csaba
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29,
hi
I start postmaster by giving the following
command
/usr/bin/pg_ctl -w -l postgreslog -D $PGDATA
-p /usr/bin/postmaster -o '-p ${PGPORT}' start
however nothing gets looged in
postgrelog.
if i see postgreslog it shows me only
this:
LOG: logger shutting downLOG:
logger shutting downL
surabhi.ahuja wrote:
hi
I start postmaster by giving the following command
/usr/bin/pg_ctl -w -l postgreslog -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start
however nothing gets looged in postgrelog.
if i see postgreslog it shows me only this:
LOG: logger shutting down
LOG: l
Dear list members,
Let me first introduce myself, I'm Martijn and currently doing my master's
thesis research at Delft University (The Netherlands). I am working in the
field of spatial databases and I am going to test, investigate and
implement a data structure which is suitable for on-the-fly g
(Oops...originally sent this to Jim, instead of the group)
Thanks for the reply...Yes, we do have ARD installed on the machine,
but I believe the postgres instance that we see running (through ps
auxw | grep postgres) is our server instance (pointed at our data
directory), not the ARD insta
On Nov 29, 2005, at 21:55 , Timothy Perrigo wrote:
We are still able to connect to our database using psql (and via
JDBC). Does this still seem like it could be an ARD conflict?
No. I think ARD is blame-free in this instance. Dunno what the issue
is, though. Sorry.
Michael Glaesemann
gr
On Nov 28, 2005, at 6:14 PM, Michael Glaesemann wrote:
[Reordering top-posted reply]
Conflicts with the ARD-installed server has been an issue for me on
and off in the past, though I haven't been able to connect to the
server using psql without specifying the ard database, user, and
pass
Tom,
Thanks for the reply...something did in fact remove the
postmaster.pid file! We will have to look into this further to track
down the culprit.
Thank you everyone for your responses!
Tim
On Nov 28, 2005, at 3:36 PM, Tom Lane wrote:
Timothy Perrigo <[EMAIL PROTECTED]> writes:
We ar
On Tue, Nov 29, 2005 at 01:03:39PM +0100, Martijn Meijers wrote:
> Dear list members,
>
>
> Let me first introduce myself, I'm Martijn and currently doing my master's
> thesis research at Delft University (The Netherlands). I am working in the
> field of spatial databases and I am going to test,
Hello All,
I run Tru64 Unix 5.1B / Alpha OSF1.
I have installed Postgresql 8.0.3 on a cluster.
The following is my pg_hba.conf,
"
hostdcs all 127.0.0.1 255.255.255.255
password
hostdcsconfig all 127.0.0.1 255.255.255.255
password
local all
On Tue, November 29, 2005 0:37, Jim C. Nasby said:
> One issue is that pg_toast tables can't vacuum rows until their
> respective rows have been deleted by vacuuming the base table. But it's
> still odd that the count decreases by 4 each time you run it.
So, VACUUM would first vacuum , then
pg_toa
Dear PSQL,I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command. I want to make the report using a database manager application, and it requires me to make my own report by typing the SQL command in it. Can you please prov
I downloaded the postgresql-8.1.0 source rpm for Fedora Core 4 from the
rpm repository at postgresql.org.
I installed the rpm with " rpm -i postgresql-8.1.0-2PGDG.src.rpm"
I then attempted to rebuild the packages with
rpmbuild --rebuild --define 'tcl 1' --define 'kerberos 0' --define
'tclde
Read the FAQ.
---
Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make the report
> using
Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make the
> report using a database manager application, and it requires me to make
> my own report by typing the SQL command
am 29.11.2005, um 1:25:37 -0800 mailte Peter Futaro folgendes:
> Can you please provide me the command behind "\d" or perhaps tell
> me what attributes do you use to build that "\d" report ?
Start psql with -E. Now you can see the sql-commands for \d and other
commands like this.
HTH, An
Peter Futaro wrote:
I need to make a documentation for my database. The documentation I want is almost exactly like the result
of "\d" command. I want to make the report using a database manager application, and it requires
me to make my own report by typing the SQL command in it. Can you
I shoul start the sequence with the last number in the higher number in
the table +1.
It works.
Sterpu Victor wrote:
I have the following table
Column | Type |Modifiers
+---+--
hi
i think i've encountered a bug in postgresql 8.1.
yet - i'm not reallty info submitting it to -bugs, as i have no way to successfully redo it again.
basically
i have server, with dual opteron, 4g of memory, 2gb of swap. everything working under centos 4.2.
postgresql 8.1 compiled from sources
On 11/29/05, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
i think i've encountered a bug in postgresql 8.1.
now i'm nearly positive it's a bug.
i created database in this way:
CREATE DATABASE leak;
\c leak
CREATE TABLE users (id serial PRIMARY KEY, username TEXT NOT NULL DEFAULT '', passwo
On Mon, 2005-11-28 at 18:39, Stock, Stuart wrote:
> FYI in case you still have the problem after using pg_dump from 8.1 (we did)
> you may have an encoding mismatch between your 7.3 and 8.1 databases. Our
> 7.x database was SQL_ASCII while 8.1 defaults to creating databases as
> UTF-8. I had simila
Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
creating template1 database in /var/lib/pgsql/data/base/1 ... FATAL:
XX000: failed to initialize lc_messages to ""
We've seen this reported occasionally before, but none of the PG
developers have ever been able to reproduce it
I have the following table
Column | Type |Modifiers
+---+-
id | integer | not null default
nextval('cachedgroupmembers_id_seq'::regclass)
groupid
Steve Crawford <[EMAIL PROTECTED]> writes:
> Summary:
> I installed glibc-locale and initdb now works fine.
Interesting. I had just come to the conclusion that you were missing
some files from this part of your strace:
[pid 5240] open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = -1
On Tue, 2005-11-29 at 18:00 +0200, Sterpu Victor wrote:
> I have the following table
...
> And the sequence for the id column:
> CREATE SEQUENCE cachedgroupmembers_id_seq CACHE 1000;
>
> Now the table is empty and I try to insert a row in this table:
> INSERT INTO cachedgroupmembers(groupid) value
I'm getting errors at the make stage for 8.1.0 on Solaris 8 despite
configure looking ok. A similar issue was reported with 8.0.3 on Solaris 10
but there didn't seem to be a resolution.
http://archives.postgresql.org/pgsql-admin/2005-09/msg00029.php
make in this instance is gmake.
utils/SUBSYS.o:
On Tue, Nov 29, 2005 at 07:53:52PM +, Janet Bagg wrote:
> I'm getting errors at the make stage for 8.1.0 on Solaris 8 despite
> configure looking ok. A similar issue was reported with 8.0.3 on Solaris 10
> but there didn't seem to be a resolution.
> http://archives.postgresql.org/pgsql-admin/20
Martijn van Oosterhout writes:
> On Tue, Nov 29, 2005 at 07:53:52PM +, Janet Bagg wrote:
>> I'm getting errors at the make stage for 8.1.0 on Solaris 8 despite
>> configure looking ok.
> Obviously isinf() is missing. Is it a documented function on that
> platform? Is there any indication whic
On Tue, Nov 29, 2005 at 03:45:00PM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Obviously isinf() is missing. Is it a documented function on that
> > platform? Is there any indication which library it is in? It's
> > obviously not in libm.
>
> What's even odder is that configure ma
Mark Cave-Ayland wrote:
> We're looking at investing in a new storage system in order to run
> PostgreSQL and the advice we are getting is to move away from our
> current SAN solution to a NAS solution. Can anyone offer any
> advice/experience on using NAS devices to run a PostgreSQL database?
The
Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
Summary:
I installed glibc-locale and initdb now works fine.
Interesting. I had just come to the conclusion that you were missing
some files...
>
the other four files all exist and are in
the glibc-common RPM, which means that i
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I wonder if this is a problem with gcc 4 on Solaris. The OP is
> using Solaris 8/gcc 4.0.2 and the previous complaint involved
> Solaris 10/gcc 4.0.0. My Solaris 9/gcc 3.4.2 box builds fine,
> as does the Solaris 10/gcc 3.3.2 box buzzard in the buildfarm
Yes, that's probably true. Depending on your pain you could also fund
development of a feature that would make this easier to deal with.
On Tue, Nov 29, 2005 at 09:43:16AM +0100, Egy?d Csaba wrote:
> Hi Jim,
> so IIUC, I will have to schedule a program on the server which reads all
> user informat
You migth also find http://pgfoundry.org/projects/newsysviews/ useful.
On Tue, Nov 29, 2005 at 01:25:37AM -0800, Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make
Are you sure this isn't just PostgreSQL caching data?
A complete testcase would help, too (ie: whatever you used to generate
the initial data).
On Tue, Nov 29, 2005 at 06:46:06PM +0100, hubert depesz lubaczewski wrote:
> On 11/29/05, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
> >
> > i
I've had a look at the config.log (see below). It seems to be returning yes
to the isinf check despite warnings. So port/isinf.c does not get compiled
on subsequent make.
configure:14213: checking for isinf
configure:14235: gcc -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith
-Winline -W
Tim Bunce <[EMAIL PROTECTED]> wrote:
> I'll guess that what you're really after is to be able to call begin_work
> again whilst an earlier begin_work is in effect and have the DBI keep a
> counter of how deeply nested the begin_work calls are. Then commit would
> decrement the counter and only comm
I am coming from Oracle & mySQL. In Oracle I can use
spool foo.txt
spool off
After this the file foo.txt shows everything the screen showed.
If I had echo on it will show the command and results. If I turn
on timing it shows there too.
With mySQL similarly I can use tee foo.txt and notee;
I could use some help with the following:
I have a database of geographic entities with attributes spread across
several tables. I need to determine which entities are unique with
respect to some of those attributes. I'm using the following query:
select p2.gazPlaceID from
(select p1.feat
On Tue, Nov 29, 2005 at 04:16:53PM -0500, Tom Lane wrote:
> On a default HPUX build you can look into /usr/local/lib/gcc-lib/ to
> discern what the compiler was actually built on; not sure if the
> equivalent directories are kept in the same place on Solaris.
The equivalent on my box is /usr/local
On Mon, Nov 28, 2005 at 03:39:37PM +0200, Peter Filipov wrote:
> I can't detect whether i passed a NULL to stored procedure
> in plpgsql when it happens that I use composites
This came up a few months ago; see Tom Lane's response to the
following message:
http://archives.postgresql.org/pgsql-sql/
On Thu, Nov 24, 2005 at 11:47:53AM +0100, A.j. Langereis wrote:
> But how can I do something like this:
>
> select my_pg_func(table2.some_col).col1
> from table2.some_col
Use another set of parentheses around the function call, as at the
end of this example:
CREATE TYPE test_type AS (col1 intege
On Tue, Nov 29, 2005 at 09:58:49PM -0500, John D. Burger wrote:
> I could use some help with the following:
>
> I have a database of geographic entities with attributes spread across
> several tables. I need to determine which entities are unique with
> respect to some of those attributes. I'm
On 11/29/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
Are you sure this isn't just PostgreSQL caching data?
i am not sure. but what bothers me is:
i setup limit of shared memory to 5 buffers - which gives estimate 400 megabytes. how come it ended up using 6GB ?
depesz
44 matches
Mail list logo
