Re: [ADMIN] CREATE USER system privilege?

QL/skripts/f_create_user.tar.gz Regards Oli Tom Lane wrote: Oli Sennhauser <[EMAIL PROTECTED]> writes: You need to use EXECUTE to construct this query as a string. Facit: pgplsql does not work for my problem, execute does not work problem. I didn't think I would have to

Re: [ADMIN] FW: FW:

.1.3 Thanks in advance Leszek Dukwicz -- --- Haben Sie Ihre Firma schon im FOSS-Directory (www.foss-directory.ch) eingetragen? Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 e-Mail [EMAIL PROTECTE

Re: [ADMIN] Database size with postgres 7.2

.. If you find something to this point I would be verry interested in. Regards Oli ------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450

Re: [ADMIN] Database size with postgres 7.2

pages * 8, relfilenode FROM pg_class WHERE relkind = 'r' ORDER BY tablename, indexname DESC, size_kb; Does it help? Regards Oli --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland P

Re: [ADMIN] CREATE USER system privilege?

r to create other users than granting superuser rights? In my opinion it is a little much privileges to just create new users. Proposal for a next release: CREATE USER system privilege. Where do I have to request for such a proposal? Regards Oli -------

Re: [ADMIN] Opinion wanted: Default select rights for users via public

on) and application should now use the new interface and the old interface will outage in 2 or 3 years. Otherwise we will never get rid of this problems. Thanks for discussing Oli ------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Re

[ADMIN] UNIX File buffering disable?

ering on mountpoints where rdbms are running. What about this? Any hints? What about PostgreSQL? Do we bypass this OS buffering (fsync?) or should a dba do anything else? How do I disable this I/O buffering? Thanks for comments Oli --- Oli Sennh

[ADMIN] Opinion wanted: Default select rights for users via public schema

access to pg_tables, etc. anymore!) Any hint is welcome Oli ------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED

[ADMIN] CREATE USER system privilege?

ql SECURITY DEFINER; ----------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website http://mypage.bluewin.ch/shinguz/Pos

[ADMIN] Shared Memory explanation/little bug?

x0052f263 720918 postgres 60017 -- Message Queues keymsqid owner perms used-bytes messages ----------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phon

[ADMIN] Experience wanted: low-cost Photo-Archive in TB range

backup that amount of data, etc. Any comment is welcome! Regards Oli --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTE

Re: [ADMIN] server & client using different version, OK?

--- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch Import the Swiss

Re: [ADMIN] Size on Disk

= 'r' ORDER BY tablename, indexname DESC, size_kb; Caution: This Sktipt does NOT exactly the same... but the results should be the same Regrards Oli --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 U

[ADMIN] Backup/Recovery (BR) question

is crashing (not a once but during some time). After restoring, it should do a redo and rollback automatically like after a crash. This methode (physical hot backup) would increas backup and restore times dramatically. Thanks for clearing up Oli ---------

Re: [ADMIN] pg_restore and FK constraints with large dbs

Where can we place wishes for PostgreSQL v7.5 and 8.0 ??? Is it pgsql-hackers ??? --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-

Re: [ADMIN] ER diagram tool for PostgresSQL7.3

Hello Gautam I was reading something about Eclipse and the Plugin "Clay Datamodel". What about this. I was just downloading (70MB) it. Installation is very easy. But is a little late now an cannot concentrate anymore... Regards Oli ------

Re: [ADMIN] Taking database offline

eed some alpha-Testers? Regards Oli ------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website http://mypage

Re: [ADMIN] ER diagram tool for PostgresSQL7.3

Hello They (architects) told me ER is out, UML is in. And they told me also, that something like ER can be done in UML. I think there are some FOSS-Tools for UML (v1.0 or v.2.0)? Regards Oli --- Oli Sennhauser Database-Engineer (Oracle

Re: [ADMIN] close connection

-fu postgres | grep T740A | grep -v grep | cut -d" " -f2 | \ while read pid ; do kill ${pid} 2>/dev/null done Regards Oli ------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone

Re: [ADMIN] performance problem - 10.000 databases

help in case of problems. They made a survey here in CH under top managers. And this is the answer they gave: They do not know where to get support. E.g. there is no company called PostgreSQL (Switzerland) Ltd. --- Oli Sennhauser Database

Re: [ADMIN] data format problem for upgrede from 7.1->7.3

-xx A dump/restore using pg_dump is required 12 months --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website

Re: [ADMIN] Creating users in a second postgres server.

???). If you like I can send you a draft. Regards Oli --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website

Re: [ADMIN] Application monitoring

=== -- --- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website http://mypage.bluewin.ch/shinguz/PostgreSQL/ Secure (signed/encrypted) e-Mail with a Free Personal SwissSig

Re: [ADMIN] data format problem for upgrede from 7.1->7.3

orget to increase your free space map settings -- ----------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website http://my

[ADMIN] Relation from database to filename of e.g. table

Hello Admins Can someone please tell me, which relation gives me the link between a database and a table? I want to find out, which table belongs to which database in a cluster. Something like SELECT d.datname, c.relname FROM pg_database d, pg_class c, pg_xxx x WHERE d.oid = x.oid AND x.oid

[ADMIN] Solution: Second postmaster / second DB cluster

Stephan Szabo wrote: On Thu, 16 Oct 2003, Oli Sennhauser wrote: I would like to start a second postmaster on my server. First problem was the lock file /tmp/.s.PGSQL.5432.lock and its socket. But you can workaround that by the -k parameter. So I was able to start at least 3 clusters... If you

[ADMIN] Second postmaster / second DB cluster

]:~/data/CLUSTER1> psql -l psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? --- Oli Sennha