}

StartTransactionCommand();

roleid=get_role_oid(shell_required_role, true);

if (!is_member_of_role(GetUserId(),roleid))

if (!has_privs_of_role(GetUserId(),roleid))

ereport(ERROR,

(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),

errmsg("permission denied to use basebackup_to_shell")));

<literal>server:/some/path</literal>, the backup will be stored on

the machine where the server is running in the

<literal>/some/path</literal> directory. Storing a backup on the

server requires superuser privileges orbeing granted the

server requires superuser privileges orhaving privileges of the

<literal>pg_write_server_files</literal> role. If the target is set to

<literal>blackhole</literal>, the contents are discarded and not

stored anywhere. This should only be used for testing purposes, as you

StartTransactionCommand();

if (!is_member_of_role(GetUserId(),ROLE_PG_WRITE_SERVER_FILES))

if (!has_privs_of_role(GetUserId(),ROLE_PG_WRITE_SERVER_FILES))

ereport(ERROR,

(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),

errmsg("must be superuser or amember of the pg_write_server_files role to create server backup")));

errmsg("must be superuser or arole with privileges of the pg_write_server_files role to create server backup")));

CommitTransactionCommand();