Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjgBg-0001VZ-FU for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 08:04:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjgBd-0005Ny-DH for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 08:04:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjgBc-0005Hd-VX for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 08:04:33 +0000 Received: from mout.kundenserver.de ([212.227.126.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjgBV-0003Sy-L8 for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 08:04:31 +0000 Received: from [10.8.0.101] ([185.40.248.10]) by mrelayeu.kundenserver.de (mreue012 [212.227.15.129]) with ESMTPSA (Nemesis) id 1MYcy3-1gnigX2F19-00VeYQ for ; Wed, 16 Jan 2019 09:04:22 +0100 Subject: Re: create tablespaces and users To: pgsql-admin@lists.postgresql.org References: <858026322.18309717.1547479488317.ref@mail.yahoo.com> <858026322.18309717.1547479488317@mail.yahoo.com> <298a21d9-c6b3-e80b-adf5-4583c9df2f70@gmx.net> <2088852869.450616.1547563351918@mail.yahoo.com> From: Thomas Kellerer Message-ID: Date: Wed, 16 Jan 2019 09:04:21 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: <2088852869.450616.1547563351918@mail.yahoo.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-GB Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:5ECBN/Ff6vJl1nSqlY//jeN4Gok1IvcEUbDsmYcjaQP6cjDWvT1 6zkuLCyc89NB1VjX0tlTE4eDJDV/zAtamgRqvLUAW8yjno1SxwbArl3oIb6iJ+bmwlCmtti XB+Drf8GJXIuAg6HsZ3UAxlWGxzRjl3hLAB49dZ51oix51dsZhnx1qFa8GnyiGfw9BnPK9/ 0TdwFUXWhDddDsz0FGtEA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:BPvBZ/WLSHE=:poO8qSTbMAImvr1RAbZ56u w0FuTDKD4OSasILRl0+/TBa+gShHk+90GPyfoZSJB6Vds7m68gW9HPCnMaJsxRZ/NXo9L0yuG ktgDPSrigoQJy6qwYfnJh5tJ3YL86VnFQKzU2zXRSpFNl6pgKVQfhcthdTaUf8mpV2vHGHkps 9CJZOe2nKxQgpfShH/S2geCkKn/LcDmhMbvJ2t2tBhCodHqD+sO7yomzzi5468Spxvr6yeNHL Ot+iGG/oOojeqqlrY7AJkIAHPOlkAUDRhnSC+SlePB7iBECcz157SQGb25SJV6faZQg8m3dgA CCCNYn+O0XWPmttD3Xfj1c3cuyuhrELMzlY05qx6/beRKbwiqBgjNbLhnFqU1NdHLM61ZiLI4 zcP5lnzNiDghfBACLAID0jweToF6R3BTTbzDDGQGyXtaeGKsPknuuUUAaX23OHBJwa2rpEfwR okImvxplJ/+avinlChznhFfGPsW5cuMyKtOcFNwDj5gVDDBYwuWz9w9Z1XVSuG2Xqc9A4aZn9 cXAV6u4eDzh6vMOkm16Gqt/sQvG10qdR49mDUaZqOKZZJhJDQYRNYG09AZLfjAcFQk5228eWi ssOa1Drc0z5ReDj3GmTw1tEr3CIiEbt0boulWE6nBIUBbozck76dOZxosPsUeuUXx5qNR4yob VFfPNn4/UkdSh4ykKSjXoVLPBsg1xH0ZcZuM6GLad/z8HI151a464vtdUacppIiiKY7wu+0zq PAiATC7fIMnxHw/NupHXTrUEfO7SG5p26XnCtQHtfja5EMAGGatdPCyyxd0= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Pepe TD Vo schrieb am 15.01.2019 um 15:42: > so you suggest not to create the tablespace and associate with the > database, right? Correct. Unless you used the tablespaces for performance optimization (e.g. spreading the I/O over multiple harddisks) I suggest to stick with the default tablespace. > What's about the owner? Still postgres or create > user owner? From Oracle we have 4 schemas for cidr database. That depends on what you want to allow the users. You can e.g. create 4 database and make each user the owner of that database. So every user has full control over their database and the data is clearly separated. If the users need to access tables from other users (e.g. in a JOIN), then it's best to create a single database with 4 schemas. In that case "postgres" should be the database owner. Then create a schema for each user (making the users the owner of those schemas), and you have a setup which is very similar to Oracle. I would also revoke all grants from the public schema, so that the users don't accidentally create objects there. Thomas