psql is the client, not the server. What user you run psql as doesn’t make a
difference, it’s what user the server is running as that makes the difference,
since it is the server that interacts with the file system. psql simply
connects to and interacts with the PostgreSQL server.
---
Israel Br
Thank you everyone for your responses. It is great to see so much feedback.
Based upon all the responses, I was able to successfully set my tablespace
doing the following:
- Using /usr/data/pgdata96_sebastien as target tablespace directory
- Permissions were set to: chmod postgres:postgres
On 11/21/19 6:48 AM, Sébastien Bihorel wrote:
Hi,
I am new to this list and reaching out because I am having troubles
setting up a local PostgreSQL database on my laptop. Maybe, as a
preamble, I should say that I am pretty much a novice trying to teach
myself and get practical experience abou
Sébastien Bihorel wrote:
Hi,
I am new to this list and reaching out because I am having troubles
setting up a local PostgreSQL database on my laptop. Maybe, as a
preamble, I should say that I am pretty much a novice trying to teach
myself and get practical experience about database and SQL qu
On Thu, 2019-11-21 at 09:11 -0600, Ron wrote:
> After adding another 350GB to the data/base filesystem, the storage team
> said that the virtual LUN on our ESX host is full. No more expansion of
> this database until and unless they create a new LUN (on storage replicated
> to a different DC us
On 11/21/19 8:59 AM, Laurenz Albe wrote:
On Thu, 2019-11-21 at 08:54 -0600, Ron wrote:
Don't create tablespaces.
Stick with the default tablespace.
Why?
Because you won't need them.
Tablespaces have a limited number of use cases:
- Distribute I/O across several devices (you can do the same
On Thu, 2019-11-21 at 08:54 -0600, Ron wrote:
> > Don't create tablespaces.
> > Stick with the default tablespace.
>
> Why?
Because you won't need them.
Tablespaces have a limited number of use cases:
- Distribute I/O across several devices (you can do the same
on a lower level using striping)
On 11/21/19 8:52 AM, Laurenz Albe wrote:
On Thu, 2019-11-21 at 09:48 -0500, Sébastien Bihorel wrote:
Now, I would like to assign a particular disk location for the tablespace used
by this database but I am getting all kinds of errors apparently linked to
folder permissions.
Don't create tables
On Thu, 2019-11-21 at 09:48 -0500, Sébastien Bihorel wrote:
> Now, I would like to assign a particular disk location for the tablespace used
> by this database but I am getting all kinds of errors apparently linked to
> folder permissions.
Don't create tablespaces.
Stick with the default tablespa
Hi,
I am new to this list and reaching out because I am having troubles setting
up a local PostgreSQL database on my laptop. Maybe, as a preamble, I should
say that I am pretty much a novice trying to teach myself and get practical
experience about database and SQL queries (I have some general ide
10 matches
Mail list logo
