Igor Korot <ikorot01@xxxxxxxxx> writes: > I'm trying to test the functionality of logging on my older Mac with > PostgreSQL 9.1. > I see that the logile is created with the owner of postgres and the > group of wheel. Well, more specifically, it's created under the OS user & group that the server is running under. > Is there a way to make it open with "<current_user><current_user>"? What current user? The SQL user name might not correspond to any OS-level entity at all. Even if it did, it's quite unlikely that the OS would permit the server process to create files owned by some other OS user --- doing so would be a giant security risk. > Or I will have to change the owner/group manuall every time I will > access the file? You can set up the log files as readable by the OS group of the server (see log_file_mode), and then grant membership in that group to whichever OS accounts you trust. You may also need to move the log directory out from under $PGDATA to make that work, since PG doesn't like world-readable data directories. regards, tom lane
