Re: [ADMIN] postgres types

should I describe type of field to have full range of 32 bits? If I describe filed as INT4, int8/bigint I'll get SIGNED integer, insn't it? Per SQL, all numbers are signed. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http

Re: [ADMIN] pg_sorttemp files

On Wed, 3 May 2000, brianb wrote: Ok, thanks. But why are they there in the first place, then? A backend crash during sorting -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Emergency questions for new bie

and creating failed: 'Cannot find a default operator class for type 1296.' Indexes don't work for timestamp in 6.5. Use datetime, or better yet upgrade to 7.0 which should be out in a few weeks. (jinx) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262

Re: [ADMIN] changing the owner of a db

On Thu, 6 Apr 2000, Tressens Lionel wrote: Is it possible to change the owner of a db after having created it ? Update the pg_database table in accordance with the user ids listed in pg_users. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED

Re: [ADMIN] User permissions

rict access with read-write vs. read-only privledges? Read and write privileges are done on a per table basis via grant and revoke. See manual entries. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Case insensitive

select * from userdata wher name = 'John' select * from userdata wher name = 'joHN' will fetch me the same results. select * from userdata where lower(name) = 'john' -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http

Re: [ADMIN] Is it possible...?...please...

terpan writes: (Postgres doesn't work with NT4 no?) Sure it does. (With cygwin library.) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Where to send patches?

the 7.0 release is cut. [EMAIL PROTECTED] If you don't want to receive messages on that list subscribe to [EMAIL PROTECTED] and you can post to any list without receiving traffic. Send mail to [EMAIL PROTECTED] to subscribe. ('subscribe' in body) -- Peter Eisentraut Sernanders väg

Re: [ADMIN] 'user' sql reserved word ?

Andre Antonio Parmeggiani writes: = create table user (user text); ERROR: parser: parse error at or near "user" USER is a reserved word in SQL92. To use it, enclose it in double quotes. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED]

Re: [ADMIN] Authentification problems with local connections

to access the database using: [postgres@10 bin]$ psql -u dpstatistics username: dpstats password: dpstats Spelling problems? -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e

Re: [ADMIN] Why idex scan not used?

On Tue, 29 Feb 2000, Andrei N.Sobchuck wrote: Is it possible to make postgresql to use index scan when it calculate MIN(id). Not currently, but it's on the todo list. -- Peter Eisentraut Sernanders vaeg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org

Re: [ADMIN] Backup of db with large objects.

. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] changing privleges in pg_user/shadow

applications programmer golden dome media http://www.gdp.net http://www.surfmichiana.com http://www.wndu.com -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] migrating administrative pieces to new install

with getting pg_dump[all] to work. Of course, temporarily disabling the password authentication would work as well. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] security

"authentication" then you can do that by setting up a different mapping file for each database. See pg_hba.conf for details. If you're using password authentication you have to set up a different password file for each database. See again pg_hba.conf. -- Peter Eisentraut Sern

Re: [ADMIN] bugs?

[EMAIL PROTECTED] http://www.ziobudda.net Italian Linux FAQ http://faq.ziobudda.net/ Italian Linux Presshttp://www.ziobudda.net/ILP/ -- Peter Eisentraut Sernanders väg 10:115 [EMAIL

Re: [ADMIN] Vacuum process.

FAX: (314)-275-3538 St. Louis, MO 63131 INTERNET: [EMAIL PROTECTED] -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Setting Transaction level doesn't work

isolation level" tells me that it is still "read commited". Any Hints ? Is there a possibility to have transaction level setted to serializable as default level? Many thanks in advance Norbert -- Peter Eisentraut Sernande

Re: [ADMIN] Vacuum script

On 1999-12-16, [EMAIL PROTECTED] mentioned: On Thu, 16 Dec 1999, Peter Eisentraut wrote: Actually such a script, called vacuumdb, with exactly those options is included in the distribution and should be installed in your bin dir right next to psql. Unfortunately, the vacuumdb script

Re: [ADMIN] Vacuum script

) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Alternate database location

of this for the next release. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Database chages log to outside

On 1999-12-11, [EMAIL PROTECTED] mentioned: I need a logging utility for postgresql server. This will (probably) be addressed in WAL (write-ahead logging(?)), due to appear eventually but, as we found out the other day, not so soon :( . -- Peter Eisentraut Sernanders väg 10

Re: [ADMIN] Number of connections

On 1999-12-11, lec mentioned: How can I find out how many users/who are currently connected to a database? The ps output on the server machine will help. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e

Re: [ADMIN] When postgres will be faster?

slow... There is no such thing as a free lunch ... -- Peter Eisentraut Sernanders vaeg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Permissions on Database and some other questions!

ally good way without making your users superusers. That is admittedly a deficiency. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Database/table limits ??????

that most file systems won't do this, but something like XFS (SGI) will. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] psql -u

the system will let you with any password. In that regard the -u switch is kind of flawed, because prompting for username and password are really two different things. But that will be fixed in the next version. -Peter -- Peter Eisentraut Sernanders vaeg 10:115 [EMAIL

Re: [ADMIN] Password protected databases and automated backups

directory using regular file backup methods. That wouldn't be a dump, so it depends on your particular needs. -- Peter Eisentraut PathWay Computing, Inc.

Re: [ADMIN] Password protected databases and automated backups

On Tue, 3 Aug 1999, Dmitry Morozovsky wrote: On Mon, 2 Aug 1999, Peter Eisentraut wrote: PE How can I organize automated database dumping for passord protected PE database? PE If you're implying something like "How do I get around entering a PE password?", that won't be s

Re: [ADMIN] Blew away postgres user -- now can't connect

not too sure about how I fixed it, but I am pretty sure it was the user IDs. -- Peter Eisentraut PathWay Computing, Inc.

[ADMIN] Authentication via PAM or NIS

"file"?) -- Peter Eisentraut PathWay Computing, Inc.

[ADMIN] Blew away postgres user -- now can't connect

the database and ran initdb again. It says 'postgres' not in pg_shadow. My pg_hba.conf has local all trust. Any clues out there? -- Peter Eisentraut PathWay Computing, Inc.

<    1   2   3   4   5