Re: [ADMIN] database quotes

The name is the oid of the database. The oid2name in contrib can help here. However this doesn't solve the problem of new information going into the WAL files before being written into the actual tables. I am unsure what would happen if the database where unable to write to table files

Re: [ADMIN] database quotes - oops I'm talking rubbish

Sorry to reply to myself Ignore me sorry I'm talking rubbish. I was forgetting all processes would be owned by the postgres user and not the database user. (The oid2name stuff is still correct) - Stuart -Original Message- From: Hernan Nuñez [mailto:[EMAIL PROTECTED]] Sent: 18 March

Re: [ADMIN] [CYGWIN] scheduling tasks under cygwin

I use at on NT to run .bat files Example for vacuum analyse: I first use at to run va.bat va.bat: c:\cygwin\bin\bash --login -i /va.sh va.sh: vacuumdb -a -z /dev/null 21 /dev/null Hope this helps, - Stuart -Original Message- From: Jean-Christophe FABRE [mailto:[EMAIL

Re: [ADMIN] client connection

You need to use psql to connect eg: psql -h 10.240.22.203 -p -U postgres -d template1 This is assumeing you used initdb as the postgres user. If you haven't used initdb the command is: initdb -D /usr/local/pgsql/data Replace this with wherever you want to place it I suspect the as port 5432

Re: [ADMIN] Problem in installing PostgreSQL7.1.2 on Windows2000

Try the pgsql-cygwin mailing list. If you installed in the default location you put the cygipc-1.09-2.tar.gz file in c:\cygwin as this is the root, else put it where ever you installed cygwin. Then do tar -zxvf cygipc-1.09-2.tar.gz Note there is a PostgreSQL README if you install the PostgreSQL

Re: [ADMIN] Where can I get Users and Roles information in PostgreSQL

Have a look at the system views pg_user and pg_group - Stuart -Original Message- From: Andy Ruhl [mailto:[EMAIL PROTECTED]] Sent: 04 February 2002 13:33 To: sreedhar Cc: PostgreSQL Subject: Re: Where can I get Users and Roles information in PostgreSQL On Mon, 4 Feb 2002,

Re: [ADMIN] system tables

pgadmin tables are not system tables; they're just used by the pgadmin tool. I believe there is an option to clean them out somewhere in pgadmin. System tables views start with pg_ - Stuart -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October

Re: [ADMIN] Changing column modifiers?

ALTER TABLE authors ADD CHECK (NOT authorfirstname = NULL); Should that be: ALTER TABLE authors ADD CHECK (NOT authorfirstname IS NULL); ? Anyway, how about something like the following: UPDATE pg_attribute SET attnotnull='t' WHERE attname='field_name' AND attrelid in (SELECT pg_class.oid FROM

Re: [ADMIN] FINAL: Multi-User PostgreSQL usage SECURITY

If you want them with the ability to alter the schema within there own database you could create them with createdb enable, create their db and then remove that privilidge, or create the db and change the db owner. I'm not sure how you'd grant them rights to create users. Maybe

Re: [ADMIN] pg_dump windows (what a mess...!)

What is the postgres database running on? Can't you just go to that machine and pg_dump? If not then you could try installing cygwin (www.cygwin.com). This will give you a unix like api and bash shell in windows. The default install also has a binary version of postgresql including tools

Re: [ADMIN] automatical start of postmaster for Windows2000

If you upgrade to the latest version of cygwin, there is a program called cygrunsrv which allows you to setup cygwin programs as services. It is worth noting there is (was?) a problem with cygwin shutdown leaving the postmaster.pid file due to windows issueing SIGHUP. I think the latest cygwin

Re: [ADMIN] Windows Version

There is now a pre-built binary that comes cygwin, available at www.cygwin.com. There is also pgsql-cygwin mailing list. - Stuart -Original Message- From: Arne Weiner [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 6:28 PM To: [EMAIL PROTECTED] Subject: Re: Windows

[ADMIN] RE: ERROR: Conditional NOTIFY is not implemented

Off the top of my head: Could you wrap it in a function: CREATE FUNCTION rs_nt() RETURNS int4 AS ' BEGIN RAISE NOTICE ''hello world''; RETURN 0; END; ' LANGUAGE 'plpgsql'; Then select this in the rule ( ie: DO (SELECT rs_nt()) ) Or: CREATE FUNCTION rs_trig() RETURNS OPAQUE AS ' BEGIN RAISE

[ADMIN] RE: Can't I do that?

Try using a select query. (eg SELECT func_name(arg1,arg2) AS result) - Stuart -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 4:30 PM To: [EMAIL PROTECTED] Subject: Can't I do that? Hi, all! I'm pretty novice in using

[ADMIN] RE: putting odbc on university server

The ODBC driver is under the LGPL so I see no reason why not (standard IANAL, etc... though). The only things you might have to do is also have the source available for download as well as the binary and also distribute a copy of the license. (I believe the full install includes such a license in

[ADMIN] RE: HELP PLEASE!! Installation on NT Machine.

Hello, have a look at: http://www.ca.postgresql.org/docs/faq-mswin Note however that cygwin now comes with prebuilt postgresql binaries so all you should need to do is to install cygwin and cygipc. Then ipc-daemon initdb -D datadirectory postmaster -i -D