]> granicus.if.org Git - postgresql/blobdiff - src/backend/utils/init/miscinit.c
Repair some REINDEX problems per recent discussions. The relcache is
[postgresql] / src / backend / utils / init / miscinit.c
index c92b79ff07ef3c239aacfef207de9a30fb7bae5a..22baac3706f6e4f2ae21afdda46578235509386f 100644 (file)
@@ -1,46 +1,61 @@
 /*-------------------------------------------------------------------------
  *
  * miscinit.c
- *       miscellanious initialization support stuff
+ *       miscellaneous initialization support stuff
  *
- * Portions Copyright (c) 1996-2000, PostgreSQL, Inc
+ * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
  *
  * IDENTIFICATION
- *       $Header: /cvsroot/pgsql/src/backend/utils/init/miscinit.c,v 1.46 2000/05/02 08:13:08 ishii Exp $
+ *       $Header: /cvsroot/pgsql/src/backend/utils/init/miscinit.c,v 1.114 2003/09/24 18:54:01 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
 #include "postgres.h"
 
 #include <sys/param.h>
-#include <sys/types.h>
 #include <signal.h>
-#include <sys/stat.h>
 #include <sys/file.h>
+#include <sys/stat.h>
+#include <sys/time.h>
 #include <fcntl.h>
 #include <unistd.h>
 #include <grp.h>
 #include <pwd.h>
-#include <stdlib.h>
+#include <errno.h>
+#include <netinet/in.h>
+#include <arpa/inet.h>
+#ifdef HAVE_UTIME_H
+#include <utime.h>
+#endif
 
 #include "catalog/catname.h"
 #include "catalog/pg_shadow.h"
+#include "libpq/libpq-be.h"
 #include "miscadmin.h"
+#include "storage/ipc.h"
+#include "storage/pg_shmem.h"
+#include "utils/builtins.h"
+#include "utils/guc.h"
+#include "utils/lsyscache.h"
 #include "utils/syscache.h"
 
 
-#ifdef CYR_RECODE
-unsigned char RecodeForwTable[128];
-unsigned char RecodeBackTable[128];
+ProcessingMode Mode = InitProcessing;
 
-#endif
+/* Note: we rely on these to initialize as zeroes */
+static char directoryLockFile[MAXPGPATH];
+static char socketLockFile[MAXPGPATH];
 
-ProcessingMode Mode = InitProcessing;
 
 /* ----------------------------------------------------------------
  *             ignoring system indexes support stuff
+ *
+ * NOTE: "ignoring system indexes" means we do not use the system indexes
+ * for lookups (either in hardwired catalog accesses or in planner-generated
+ * plans).  We do, however, still update the indexes when a catalog
+ * modification is made.
  * ----------------------------------------------------------------
  */
 
@@ -51,15 +66,14 @@ static bool isIgnoringSystemIndexes = false;
  *             True if ignoring system indexes.
  */
 bool
-IsIgnoringSystemIndexes()
+IsIgnoringSystemIndexes(void)
 {
        return isIgnoringSystemIndexes;
 }
 
 /*
  * IgnoreSystemIndexes
- *     Set true or false whether PostgreSQL ignores system indexes.
- *
+ *             Set true or false whether PostgreSQL ignores system indexes.
  */
 void
 IgnoreSystemIndexes(bool mode)
@@ -67,6 +81,53 @@ IgnoreSystemIndexes(bool mode)
        isIgnoringSystemIndexes = mode;
 }
 
+/* ----------------------------------------------------------------
+ *             system index reindexing support
+ *
+ * When we are busy reindexing a system index, this code provides support
+ * for preventing catalog lookups from using that index.
+ * ----------------------------------------------------------------
+ */
+
+static Oid     currentlyReindexedHeap = InvalidOid;
+static Oid     currentlyReindexedIndex = InvalidOid;
+
+/*
+ * ReindexIsProcessingHeap
+ *             True if heap specified by OID is currently being reindexed.
+ */
+bool
+ReindexIsProcessingHeap(Oid heapOid)
+{
+       return heapOid == currentlyReindexedHeap;
+}
+
+/*
+ * ReindexIsProcessingIndex
+ *             True if index specified by OID is currently being reindexed.
+ */
+bool
+ReindexIsProcessingIndex(Oid indexOid)
+{
+       return indexOid == currentlyReindexedIndex;
+}
+
+/*
+ * SetReindexProcessing
+ *             Set flag that specified heap/index are being reindexed.
+ *             Pass InvalidOid to indicate that reindexing is not active.
+ */
+void
+SetReindexProcessing(Oid heapOid, Oid indexOid)
+{
+       /* Args should be both, or neither, InvalidOid */
+       Assert((heapOid == InvalidOid) == (indexOid == InvalidOid));
+       /* Reindexing is not re-entrant. */
+       Assert(indexOid == InvalidOid || currentlyReindexedIndex == InvalidOid);
+       currentlyReindexedHeap = heapOid;
+       currentlyReindexedIndex = indexOid;
+}
+
 /* ----------------------------------------------------------------
  *                             database path / name support stuff
  * ----------------------------------------------------------------
@@ -75,7 +136,11 @@ IgnoreSystemIndexes(bool mode)
 void
 SetDatabasePath(const char *path)
 {
-       free(DatabasePath);
+       if (DatabasePath)
+       {
+               free(DatabasePath);
+               DatabasePath = NULL;
+       }
        /* use strdup since this is done before memory contexts are set up */
        if (path)
        {
@@ -84,439 +149,798 @@ SetDatabasePath(const char *path)
        }
 }
 
+/*
+ * Set data directory, but make sure it's an absolute path.  Use this,
+ * never set DataDir directly.
+ */
 void
-SetDatabaseName(const char *name)
+SetDataDir(const char *dir)
 {
-       free(DatabaseName);
-       if (name)
+       char       *new;
+       int                     newlen;
+
+       AssertArg(dir);
+
+       /* If presented path is relative, convert to absolute */
+       if (!is_absolute_path(dir))
+       {
+               char       *buf;
+               size_t          buflen;
+
+               buflen = MAXPGPATH;
+               for (;;)
+               {
+                       buf = malloc(buflen);
+                       if (!buf)
+                               ereport(FATAL,
+                                               (errcode(ERRCODE_OUT_OF_MEMORY),
+                                                errmsg("out of memory")));
+
+                       if (getcwd(buf, buflen))
+                               break;
+                       else if (errno == ERANGE)
+                       {
+                               free(buf);
+                               buflen *= 2;
+                               continue;
+                       }
+                       else
+                       {
+                               free(buf);
+                               elog(FATAL, "could not get current working directory: %m");
+                       }
+               }
+
+               new = malloc(strlen(buf) + 1 + strlen(dir) + 1);
+               if (!new)
+                       ereport(FATAL,
+                                       (errcode(ERRCODE_OUT_OF_MEMORY),
+                                        errmsg("out of memory")));
+               sprintf(new, "%s/%s", buf, dir);
+               free(buf);
+       }
+       else
        {
-               DatabaseName = strdup(name);
-               AssertState(DatabaseName);
+               new = strdup(dir);
+               if (!new)
+                       ereport(FATAL,
+                                       (errcode(ERRCODE_OUT_OF_MEMORY),
+                                        errmsg("out of memory")));
        }
+
+       /*
+        * Strip any trailing slash.  Not strictly necessary, but avoids
+        * generating funny-looking paths to individual files.
+        */
+       newlen = strlen(new);
+       if (newlen > 1 && new[newlen - 1] == '/'
+#ifdef WIN32
+               || new[newlen - 1] == '\\'
+#endif
+               )
+               new[newlen - 1] = '\0';
+
+       if (DataDir)
+               free(DataDir);
+       DataDir = new;
 }
 
-#ifndef MULTIBYTE
-/* even if MULTIBYTE is not enabled, this function is neccesary
- * since pg_proc.h has entries for them.
+
+/* ----------------------------------------------------------------
+ *     User ID things
+ *
+ * The authenticated user is determined at connection start and never
+ * changes.  The session user can be changed only by SET SESSION
+ * AUTHORIZATION.  The current user may change when "setuid" functions
+ * are implemented.  Conceptually there is a stack, whose bottom
+ * is the session user.  You are yourself responsible to save and
+ * restore the current user id if you need to change it.
+ * ----------------------------------------------------------------
  */
-const char *
-getdatabaseencoding()
+static AclId AuthenticatedUserId = 0;
+static AclId SessionUserId = 0;
+static AclId CurrentUserId = 0;
+
+static bool AuthenticatedUserIsSuperuser = false;
+
+/*
+ * This function is relevant for all privilege checks.
+ */
+AclId
+GetUserId(void)
 {
-       return ("SQL_ASCII");
+       AssertState(AclIdIsValid(CurrentUserId));
+       return CurrentUserId;
 }
 
-const char *
-pg_encoding_to_char(int encoding)
+
+void
+SetUserId(AclId newid)
 {
-       return ("SQL_ASCII");
+       AssertArg(AclIdIsValid(newid));
+       CurrentUserId = newid;
 }
 
-int
-pg_char_to_encoding(const char *encoding_string)
+
+/*
+ * This value is only relevant for informational purposes.
+ */
+AclId
+GetSessionUserId(void)
 {
-       return (0);
+       AssertState(AclIdIsValid(SessionUserId));
+       return SessionUserId;
 }
 
-#endif
-
-#ifdef CYR_RECODE
-#define MAX_TOKEN      80
 
-/* Some standard C libraries, including GNU, have an isblank() function.
-   Others, including Solaris, do not.  So we have our own.
-*/
-static bool
-isblank(const char c)
+void
+SetSessionUserId(AclId newid)
 {
-       return c == ' ' || c == 9 /* tab */ ;
+       AssertArg(AclIdIsValid(newid));
+       SessionUserId = newid;
+       /* Current user defaults to session user. */
+       if (!AclIdIsValid(CurrentUserId))
+               CurrentUserId = newid;
 }
 
-static void
-next_token(FILE *fp, char *buf, const int bufsz)
+
+void
+InitializeSessionUserId(const char *username)
 {
-/*--------------------------------------------------------------------------
-  Grab one token out of fp.  Tokens are strings of non-blank
-  characters bounded by blank characters, beginning of line, and end
-  of line.     Blank means space or tab.  Return the token as *buf.
-  Leave file positioned to character immediately after the token or
-  EOF, whichever comes first.  If no more tokens on line, return null
-  string as *buf and position file to beginning of next line or EOF,
-  whichever comes first.
---------------------------------------------------------------------------*/
-       int                     c;
-       char       *eb = buf + (bufsz - 1);
-
-       /* Move over inital token-delimiting blanks */
-       while (isblank(c = getc(fp)));
-
-       if (c != '\n')
-       {
+       HeapTuple       userTup;
+       Datum           datum;
+       bool            isnull;
+       AclId           usesysid;
 
-               /*
-                * build a token in buf of next characters up to EOF, eol, or
-                * blank.
-                */
-               while (c != EOF && c != '\n' && !isblank(c))
-               {
-                       if (buf < eb)
-                               *buf++ = c;
-                       c = getc(fp);
+       /*
+        * Don't do scans if we're bootstrapping, none of the system catalogs
+        * exist yet, and they should be owned by postgres anyway.
+        */
+       AssertState(!IsBootstrapProcessingMode());
 
-                       /*
-                        * Put back the char right after the token (putting back EOF
-                        * is ok)
-                        */
-               }
-               ungetc(c, fp);
+       /* call only once */
+       AssertState(!OidIsValid(AuthenticatedUserId));
+
+       userTup = SearchSysCache(SHADOWNAME,
+                                                        PointerGetDatum(username),
+                                                        0, 0, 0);
+       if (!HeapTupleIsValid(userTup))
+               ereport(FATAL,
+                               (errcode(ERRCODE_UNDEFINED_OBJECT),
+                                errmsg("user \"%s\" does not exist", username)));
+
+       usesysid = ((Form_pg_shadow) GETSTRUCT(userTup))->usesysid;
+
+       AuthenticatedUserId = usesysid;
+       AuthenticatedUserIsSuperuser = ((Form_pg_shadow) GETSTRUCT(userTup))->usesuper;
+
+       SetSessionUserId(usesysid); /* sets CurrentUserId too */
+
+       /* Record username and superuser status as GUC settings too */
+       SetConfigOption("session_authorization", username,
+                                       PGC_BACKEND, PGC_S_OVERRIDE);
+       SetConfigOption("is_superuser",
+                                       AuthenticatedUserIsSuperuser ? "on" : "off",
+                                       PGC_INTERNAL, PGC_S_OVERRIDE);
+
+       /*
+        * Set up user-specific configuration variables.  This is a good place
+        * to do it so we don't have to read pg_shadow twice during session
+        * startup.
+        */
+       datum = SysCacheGetAttr(SHADOWNAME, userTup,
+                                                       Anum_pg_shadow_useconfig, &isnull);
+       if (!isnull)
+       {
+               ArrayType  *a = DatumGetArrayTypeP(datum);
+
+               ProcessGUCArray(a, PGC_S_USER);
        }
-       *buf = '\0';
+
+       ReleaseSysCache(userTup);
 }
 
-static void
-read_through_eol(FILE *file)
+
+void
+InitializeSessionUserIdStandalone(void)
 {
-       int                     c;
+       /* This function should only be called in a single-user backend. */
+       AssertState(!IsUnderPostmaster);
+
+       /* call only once */
+       AssertState(!OidIsValid(AuthenticatedUserId));
+
+       AuthenticatedUserId = BOOTSTRAP_USESYSID;
+       AuthenticatedUserIsSuperuser = true;
 
-       do
-               c = getc(file);
-       while (c != '\n' && c != EOF);
+       SetSessionUserId(BOOTSTRAP_USESYSID);
 }
 
+
+/*
+ * Change session auth ID while running
+ *
+ * Only a superuser may set auth ID to something other than himself.  Note
+ * that in case of multiple SETs in a single session, the original userid's
+ * superuserness is what matters.  But we set the GUC variable is_superuser
+ * to indicate whether the *current* session userid is a superuser.
+ */
 void
-SetCharSet()
+SetSessionAuthorization(AclId userid, bool is_superuser)
 {
-       FILE       *file;
-       char       *p,
-                               c,
-                               eof = false;
-       char       *map_file;
-       char            buf[MAX_TOKEN];
-       int                     i;
-       unsigned char FromChar,
-                               ToChar;
-
-       for (i = 0; i < 128; i++)
+       /* Must have authenticated already, else can't make permission check */
+       AssertState(AclIdIsValid(AuthenticatedUserId));
+
+       if (userid != AuthenticatedUserId &&
+               !AuthenticatedUserIsSuperuser)
+               ereport(ERROR,
+                               (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
+                         errmsg("permission denied to set session authorization")));
+
+       SetSessionUserId(userid);
+       SetUserId(userid);
+
+       SetConfigOption("is_superuser",
+                                       is_superuser ? "on" : "off",
+                                       PGC_INTERNAL, PGC_S_OVERRIDE);
+}
+
+
+/*
+ * Get user name from user id
+ */
+char *
+GetUserNameFromId(AclId userid)
+{
+       HeapTuple       tuple;
+       char       *result;
+
+       tuple = SearchSysCache(SHADOWSYSID,
+                                                  ObjectIdGetDatum(userid),
+                                                  0, 0, 0);
+       if (!HeapTupleIsValid(tuple))
+               ereport(ERROR,
+                               (errcode(ERRCODE_UNDEFINED_OBJECT),
+                                errmsg("invalid user id: %d", userid)));
+
+       result = pstrdup(NameStr(((Form_pg_shadow) GETSTRUCT(tuple))->usename));
+
+       ReleaseSysCache(tuple);
+       return result;
+}
+
+
+
+/*-------------------------------------------------------------------------
+ *                             Interlock-file support
+ *
+ * These routines are used to create both a data-directory lockfile
+ * ($DATADIR/postmaster.pid) and a Unix-socket-file lockfile ($SOCKFILE.lock).
+ * Both kinds of files contain the same info:
+ *
+ *             Owning process' PID
+ *             Data directory path
+ *
+ * By convention, the owning process' PID is negated if it is a standalone
+ * backend rather than a postmaster.  This is just for informational purposes.
+ * The path is also just for informational purposes (so that a socket lockfile
+ * can be more easily traced to the associated postmaster).
+ *
+ * A data-directory lockfile can optionally contain a third line, containing
+ * the key and ID for the shared memory block used by this postmaster.
+ *
+ * On successful lockfile creation, a proc_exit callback to remove the
+ * lockfile is automatically created.
+ *-------------------------------------------------------------------------
+ */
+
+/*
+ * proc_exit callback to remove a lockfile.
+ */
+static void
+UnlinkLockFile(int status, Datum filename)
+{
+       char       *fname = (char *) DatumGetPointer(filename);
+
+       if (fname != NULL)
        {
-               RecodeForwTable[i] = i + 128;
-               RecodeBackTable[i] = i + 128;
+               if (unlink(fname) != 0)
+               {
+                       /* Should we complain if the unlink fails? */
+               }
+               free(fname);
        }
+}
 
-       p = getenv("PG_RECODETABLE");
-       if (p && *p != '\0')
+/*
+ * Create a lockfile.
+ *
+ * filename is the name of the lockfile to create.
+ * amPostmaster is used to determine how to encode the output PID.
+ * isDDLock and refName are used to determine what error message to produce.
+ */
+static void
+CreateLockFile(const char *filename, bool amPostmaster,
+                          bool isDDLock, const char *refName)
+{
+       int                     fd;
+       char            buffer[MAXPGPATH + 100];
+       int                     ntries;
+       int                     len;
+       int                     encoded_pid;
+       pid_t           other_pid;
+       pid_t           my_pid = getpid();
+
+       /*
+        * We need a loop here because of race conditions.      But don't loop
+        * forever (for example, a non-writable $PGDATA directory might cause
+        * a failure that won't go away).  100 tries seems like plenty.
+        */
+       for (ntries = 0;; ntries++)
        {
-               map_file = (char *) malloc((strlen(DataDir) +
-                                                                       strlen(p) + 2) * sizeof(char));
-               sprintf(map_file, "%s/%s", DataDir, p);
-#ifndef __CYGWIN32__
-               file = AllocateFile(map_file, "r");
-#else
-               file = AllocateFile(map_file, "rb");
+               /*
+                * Try to create the lock file --- O_EXCL makes this atomic.
+                */
+               fd = open(filename, O_RDWR | O_CREAT | O_EXCL, 0600);
+               if (fd >= 0)
+                       break;                          /* Success; exit the retry loop */
+
+               /*
+                * Couldn't create the pid file. Probably it already exists.
+                */
+               if ((errno != EEXIST && errno != EACCES) || ntries > 100)
+                       ereport(FATAL,
+                                       (errcode_for_file_access(),
+                                        errmsg("could not create lock file \"%s\": %m",
+                                                       filename)));
+
+               /*
+                * Read the file to get the old owner's PID.  Note race condition
+                * here: file might have been deleted since we tried to create it.
+                */
+               fd = open(filename, O_RDONLY, 0600);
+               if (fd < 0)
+               {
+                       if (errno == ENOENT)
+                               continue;               /* race condition; try again */
+                       ereport(FATAL,
+                                       (errcode_for_file_access(),
+                                        errmsg("could not open lock file \"%s\": %m",
+                                                       filename)));
+               }
+               if ((len = read(fd, buffer, sizeof(buffer) - 1)) <= 0)
+                       ereport(FATAL,
+                                       (errcode_for_file_access(),
+                                        errmsg("could not read lock file \"%s\": %m",
+                                                       filename)));
+               close(fd);
+
+               buffer[len] = '\0';
+               encoded_pid = atoi(buffer);
+
+               /* if pid < 0, the pid is for postgres, not postmaster */
+               other_pid = (pid_t) (encoded_pid < 0 ? -encoded_pid : encoded_pid);
+
+               if (other_pid <= 0)
+                       elog(FATAL, "bogus data in lock file \"%s\"", filename);
+
+               /*
+                * Check to see if the other process still exists
+                *
+                * Normally kill() will fail with ESRCH if the given PID doesn't
+                * exist.  BeOS returns EINVAL for some silly reason, however.
+                */
+               if (other_pid != my_pid)
+               {
+                       if (kill(other_pid, 0) == 0 ||
+                               (errno != ESRCH
+#ifdef __BEOS__
+                                && errno != EINVAL
 #endif
-               if (file == NULL)
-                       return;
-               eof = false;
-               while (!eof)
+                                ))
+                       {
+                               /* lockfile belongs to a live process */
+                               ereport(FATAL,
+                                               (errcode(ERRCODE_LOCK_FILE_EXISTS),
+                                                errmsg("lock file \"%s\" already exists",
+                                                               filename),
+                                                isDDLock ?
+                                        errhint("Is another %s (pid %d) running in \"%s\"?",
+                                                  (encoded_pid < 0 ? "postgres" : "postmaster"),
+                                                        (int) other_pid, refName) :
+                                                errhint("Is another %s (pid %d) using \"%s\"?",
+                                                  (encoded_pid < 0 ? "postgres" : "postmaster"),
+                                                                (int) other_pid, refName)));
+                       }
+               }
+
+               /*
+                * No, the creating process did not exist.      However, it could be
+                * that the postmaster crashed (or more likely was kill -9'd by a
+                * clueless admin) but has left orphan backends behind.  Check for
+                * this by looking to see if there is an associated shmem segment
+                * that is still in use.
+                */
+               if (isDDLock)
                {
-                       c = getc(file);
-                       ungetc(c, file);
-                       if (c == EOF)
-                               eof = true;
-                       else
+                       char       *ptr;
+                       unsigned long id1,
+                                               id2;
+
+                       ptr = strchr(buffer, '\n');
+                       if (ptr != NULL &&
+                               (ptr = strchr(ptr + 1, '\n')) != NULL)
                        {
-                               if (c == '#')
-                                       read_through_eol(file);
-                               else
+                               ptr++;
+                               if (sscanf(ptr, "%lu %lu", &id1, &id2) == 2)
                                {
-                                       /* Read the FromChar */
-                                       next_token(file, buf, sizeof(buf));
-                                       if (buf[0] != '\0')
-                                       {
-                                               FromChar = strtoul(buf, 0, 0);
-                                               /* Read the ToChar */
-                                               next_token(file, buf, sizeof(buf));
-                                               if (buf[0] != '\0')
-                                               {
-                                                       ToChar = strtoul(buf, 0, 0);
-                                                       RecodeForwTable[FromChar - 128] = ToChar;
-                                                       RecodeBackTable[ToChar - 128] = FromChar;
-                                               }
-                                               read_through_eol(file);
-                                       }
+                                       if (PGSharedMemoryIsInUse(id1, id2))
+                                               ereport(FATAL,
+                                                               (errcode(ERRCODE_LOCK_FILE_EXISTS),
+                                                          errmsg("pre-existing shared memory block "
+                                                                         "(key %lu, id %lu) is still in use",
+                                                                         id1, id2),
+                                                          errhint("If you're sure there are no old "
+                                                                          "backends still running, remove "
+                                                                          "the shared memory block with "
+                                                                          "ipcrm(1), or just delete \"%s\".",
+                                                                          filename)));
                                }
                        }
                }
-               FreeFile(file);
-               free(map_file);
-       }
-}
 
-char *
-convertstr(unsigned char *buff, int len, int dest)
-{
-       int                     i;
-       char       *ch = buff;
+               /*
+                * Looks like nobody's home.  Unlink the file and try again to
+                * create it.  Need a loop because of possible race condition
+                * against other would-be creators.
+                */
+               if (unlink(filename) < 0)
+                       ereport(FATAL,
+                                       (errcode_for_file_access(),
+                                        errmsg("could not remove old lock file \"%s\": %m",
+                                                       filename),
+                                        errhint("The file seems accidentally left over, but "
+                                                 "I couldn't remove it. Please remove the file "
+                                                        "by hand and try again.")));
+       }
 
-       for (i = 0; i < len; i++, buff++)
+       /*
+        * Successfully created the file, now fill it.
+        */
+       snprintf(buffer, sizeof(buffer), "%d\n%s\n",
+                        amPostmaster ? (int) my_pid : -((int) my_pid),
+                        DataDir);
+       errno = 0;
+       if (write(fd, buffer, strlen(buffer)) != strlen(buffer))
        {
-               if (*buff > 127)
-                       if (dest)
-                               *buff = RecodeForwTable[*buff - 128];
-                       else
-                               *buff = RecodeBackTable[*buff - 128];
+               int                     save_errno = errno;
+
+               close(fd);
+               unlink(filename);
+               /* if write didn't set errno, assume problem is no disk space */
+               errno = save_errno ? save_errno : ENOSPC;
+               ereport(FATAL,
+                               (errcode_for_file_access(),
+                         errmsg("could not write lock file \"%s\": %m", filename)));
        }
-       return ch;
-}
+       close(fd);
 
-#endif
+       /*
+        * Arrange for automatic removal of lockfile at proc_exit.
+        */
+       on_proc_exit(UnlinkLockFile, PointerGetDatum(strdup(filename)));
+}
 
-/* ----------------
- *             GetPgUserName and SetPgUserName
- *
- *             SetPgUserName must be called before InitPostgres, since the setuid()
- *             is done there.
- *
- *             Replace GetPgUserName() with a lower-case version
- *             to allow use in new case-insensitive SQL (referenced
- *             in pg_proc.h). Define GetPgUserName() as a macro - tgl 97/04/26
- * ----------------
- */
-char *
-getpgusername()
+void
+CreateDataDirLockFile(const char *datadir, bool amPostmaster)
 {
-       return UserName;
+       char            lockfile[MAXPGPATH];
+
+       snprintf(lockfile, sizeof(lockfile), "%s/postmaster.pid", datadir);
+       CreateLockFile(lockfile, amPostmaster, true, datadir);
+       /* Save name of lockfile for RecordSharedMemoryInLockFile */
+       strcpy(directoryLockFile, lockfile);
 }
 
 void
-SetPgUserName()
+CreateSocketLockFile(const char *socketfile, bool amPostmaster)
 {
-#ifndef NO_SECURITY
-       char       *p;
-       struct passwd *pw;
+       char            lockfile[MAXPGPATH];
 
-       if (IsUnderPostmaster)
-       {
-               /* use the (possibly) authenticated name that's provided */
-               if (!(p = getenv("PG_USER")))
-                       elog(FATAL, "SetPgUserName: PG_USER environment variable is unset");
-       }
-       else
-       {
-               /* setuid() has not yet been done, see above comment */
-               if (!(pw = getpwuid(geteuid())))
-                       elog(FATAL, "SetPgUserName: no entry in host passwd file");
-               p = pw->pw_name;
-       }
-       if (UserName)
-               free(UserName);
-       UserName = malloc(strlen(p) + 1);
-       strcpy(UserName, p);
-#endif  /* NO_SECURITY */
+       snprintf(lockfile, sizeof(lockfile), "%s.lock", socketfile);
+       CreateLockFile(lockfile, amPostmaster, false, socketfile);
+       /* Save name of lockfile for TouchSocketLockFile */
+       strcpy(socketLockFile, lockfile);
 }
 
-/* ----------------------------------------------------------------
- *             GetUserId and SetUserId
- * ----------------------------------------------------------------
+/*
+ * TouchSocketLockFile -- mark socket lock file as recently accessed
+ *
+ * This routine should be called every so often to ensure that the lock file
+ * has a recent mod or access date.  That saves it
+ * from being removed by overenthusiastic /tmp-directory-cleaner daemons.
+ * (Another reason we should never have put the socket file in /tmp...)
  */
-static Oid     UserId = InvalidOid;
-
-int
-GetUserId()
+void
+TouchSocketLockFile(void)
 {
-       AssertState(OidIsValid(UserId));
-       return UserId;
+       /* Do nothing if we did not create a socket... */
+       if (socketLockFile[0] != '\0')
+       {
+               /*
+                * utime() is POSIX standard, utimes() is a common alternative; if
+                * we have neither, fall back to actually reading the file (which
+                * only sets the access time not mod time, but that should be
+                * enough in most cases).  In all paths, we ignore errors.
+                */
+#ifdef HAVE_UTIME
+               utime(socketLockFile, NULL);
+#else                                                  /* !HAVE_UTIME */
+#ifdef HAVE_UTIMES
+               utimes(socketLockFile, NULL);
+#else                                                  /* !HAVE_UTIMES */
+               int                     fd;
+               char            buffer[1];
+
+               fd = open(socketLockFile, O_RDONLY | PG_BINARY, 0);
+               if (fd >= 0)
+               {
+                       read(fd, buffer, sizeof(buffer));
+                       close(fd);
+               }
+#endif   /* HAVE_UTIMES */
+#endif   /* HAVE_UTIME */
+       }
 }
 
+/*
+ * Append information about a shared memory segment to the data directory
+ * lock file (if we have created one).
+ *
+ * This may be called multiple times in the life of a postmaster, if we
+ * delete and recreate shmem due to backend crash.     Therefore, be prepared
+ * to overwrite existing information.  (As of 7.1, a postmaster only creates
+ * one shm seg at a time; but for the purposes here, if we did have more than
+ * one then any one of them would do anyway.)
+ */
 void
-SetUserId()
+RecordSharedMemoryInLockFile(unsigned long id1, unsigned long id2)
 {
-       HeapTuple       userTup;
-       char       *userName;
+       int                     fd;
+       int                     len;
+       char       *ptr;
+       char            buffer[BLCKSZ];
+
+       /*
+        * Do nothing if we did not create a lockfile (probably because we are
+        * running standalone).
+        */
+       if (directoryLockFile[0] == '\0')
+               return;
 
-       AssertState(!OidIsValid(UserId));       /* only once */
+       fd = open(directoryLockFile, O_RDWR | PG_BINARY, 0);
+       if (fd < 0)
+       {
+               ereport(LOG,
+                               (errcode_for_file_access(),
+                                errmsg("could not rewrite \"%s\": %m",
+                                               directoryLockFile)));
+               return;
+       }
+       len = read(fd, buffer, sizeof(buffer) - 100);
+       if (len <= 0)
+       {
+               ereport(LOG,
+                               (errcode_for_file_access(),
+                                errmsg("could not read \"%s\": %m",
+                                               directoryLockFile)));
+               close(fd);
+               return;
+       }
+       buffer[len] = '\0';
 
        /*
-        * Don't do scans if we're bootstrapping, none of the system catalogs
-        * exist yet, and they should be owned by postgres anyway.
+        * Skip over first two lines (PID and path).
         */
-       if (IsBootstrapProcessingMode())
+       ptr = strchr(buffer, '\n');
+       if (ptr == NULL ||
+               (ptr = strchr(ptr + 1, '\n')) == NULL)
        {
-               UserId = geteuid();
+               elog(LOG, "bogus data in \"%s\"", directoryLockFile);
+               close(fd);
                return;
        }
+       ptr++;
 
-       userName = GetPgUserName();
-       userTup = SearchSysCacheTuple(SHADOWNAME,
-                                                                 PointerGetDatum(userName),
-                                                                 0, 0, 0);
-       if (!HeapTupleIsValid(userTup))
-               elog(FATAL, "SetUserId: user '%s' is not in '%s'",
-                        userName,
-                        ShadowRelationName);
-       UserId = (Oid) ((Form_pg_shadow) GETSTRUCT(userTup))->usesysid;
+       /*
+        * Append key information.      Format to try to keep it the same length
+        * always (trailing junk won't hurt, but might confuse humans).
+        */
+       sprintf(ptr, "%9lu %9lu\n", id1, id2);
+
+       /*
+        * And rewrite the data.  Since we write in a single kernel call, this
+        * update should appear atomic to onlookers.
+        */
+       len = strlen(buffer);
+       errno = 0;
+       if (lseek(fd, (off_t) 0, SEEK_SET) != 0 ||
+               (int) write(fd, buffer, len) != len)
+       {
+               /* if write didn't set errno, assume problem is no disk space */
+               if (errno == 0)
+                       errno = ENOSPC;
+               ereport(LOG,
+                               (errcode_for_file_access(),
+                                errmsg("could not write \"%s\": %m",
+                                               directoryLockFile)));
+               close(fd);
+               return;
+       }
+       close(fd);
 }
 
+
 /*-------------------------------------------------------------------------
- *
- * posmaster pid file stuffs. $DATADIR/postmaster.pid is created when:
- *
- *     (1) postmaster starts. In this case pid > 0.
- *     (2) postgres starts in standalone mode. In this case
- *             pid < 0
- *
- * to gain an interlock.
- *
- *     SetPidFname(datadir)
- *             Remember the the pid file name. This is neccesary
- *             UnlinkPidFile() is called from proc_exit().
- *
- *     GetPidFname(datadir)
- *             Get the pid file name. SetPidFname() should be called
- *             before GetPidFname() gets called.
- *
- *     UnlinkPidFile()
- *             This is called from proc_exit() and unlink the pid file.
- *
- *     SetPidFile(pid_t pid)
- *             Create the pid file. On failure, it checks if the process
- *             actually exists or not. SetPidFname() should be called
- *             in prior to calling SetPidFile().
- *
+ *                             Version checking support
  *-------------------------------------------------------------------------
  */
 
 /*
- * Path to pid file. proc_exit() remember it to unlink the file.
- */
-static char PidFile[MAXPGPATH];
-
-/*
- * Remove the pid file. This function is called from proc_exit.
+ * Determine whether the PG_VERSION file in directory `path' indicates
+ * a data version compatible with the version of this program.
+ *
+ * If compatible, return. Otherwise, ereport(FATAL).
  */
 void
-UnlinkPidFile(void)
+ValidatePgVersion(const char *path)
 {
-       unlink(PidFile);
-}
+       char            full_path[MAXPGPATH];
+       FILE       *file;
+       int                     ret;
+       long            file_major,
+                               file_minor;
+       long            my_major = 0,
+                               my_minor = 0;
+       char       *endptr;
+       const char *version_string = PG_VERSION;
+
+       my_major = strtol(version_string, &endptr, 10);
+       if (*endptr == '.')
+               my_minor = strtol(endptr + 1, NULL, 10);
+
+       snprintf(full_path, sizeof(full_path), "%s/PG_VERSION", path);
+
+       file = AllocateFile(full_path, "r");
+       if (!file)
+       {
+               if (errno == ENOENT)
+                       ereport(FATAL,
+                                       (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
+                                        errmsg("\"%s\" is not a valid data directory",
+                                                       path),
+                                        errdetail("File \"%s\" is missing.", full_path)));
+               else
+                       ereport(FATAL,
+                                       (errcode_for_file_access(),
+                                        errmsg("could not open \"%s\": %m", full_path)));
+       }
 
-/*
- * Set path to the pid file
- */
-void
-SetPidFname(char *datadir)
-{
-       snprintf(PidFile, sizeof(PidFile), "%s/%s", datadir, PIDFNAME);
+       ret = fscanf(file, "%ld.%ld", &file_major, &file_minor);
+       if (ret != 2)
+               ereport(FATAL,
+                               (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
+                                errmsg("\"%s\" is not a valid data directory",
+                                               path),
+                                errdetail("File \"%s\" does not contain valid data.",
+                                                  full_path),
+                                errhint("You may need to initdb.")));
+
+       FreeFile(file);
+
+       if (my_major != file_major || my_minor != file_minor)
+               ereport(FATAL,
+                               (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
+                                errmsg("database files are incompatible with server"),
+                                errdetail("The data directory was initialized by PostgreSQL version %ld.%ld, "
+                                                "which is not compatible with this version %s.",
+                                                  file_major, file_minor, version_string)));
 }
 
-/*
- * Get path to the pid file
+/*-------------------------------------------------------------------------
+ *                             Library preload support
+ *-------------------------------------------------------------------------
  */
-char *
-GetPidFname(void)
-{
-       return (PidFile);
-}
+
+#if defined(__mc68000__) && defined(__ELF__)
+typedef int32 ((*func_ptr) ());
+
+#else
+typedef char *((*func_ptr) ());
+#endif
 
 /*
- * Create the pid file
+ * process any libraries that should be preloaded and
+ * optionally pre-initialized
  */
-int
-SetPidFile(pid_t pid)
+void
+process_preload_libraries(char *preload_libraries_string)
 {
-       int                     fd;
-       char       *pidfile;
-       char            pidstr[32];
-       int                     len;
-       pid_t           post_pid;
-       int                     is_postgres = 0;
+       char       *rawstring;
+       List       *elemlist;
+       List       *l;
 
-       /*
-        * Creating pid file
-        */
-       pidfile = GetPidFname();
-       fd = open(pidfile, O_RDWR | O_CREAT | O_EXCL, 0600);
-       if (fd < 0)
-       {
+       if (preload_libraries_string == NULL)
+               return;
 
-               /*
-                * Couldn't create the pid file. Probably it already exists. Read
-                * the file to see if the process actually exists
-                */
-               fd = open(pidfile, O_RDONLY, 0600);
-               if (fd < 0)
-               {
-                       fprintf(stderr, "Can't open pid file: %s\n", pidfile);
-                       fprintf(stderr, "Please check the permission and try again.\n");
-                       return (-1);
-               }
-               if ((len = read(fd, pidstr, sizeof(pidstr) - 1)) < 0)
-               {
-                       fprintf(stderr, "Can't read pid file: %s\n", pidfile);
-                       fprintf(stderr, "Please check the permission and try again.\n");
-                       close(fd);
-                       return (-1);
-               }
-               close(fd);
+       /* Need a modifiable copy of string */
+       rawstring = pstrdup(preload_libraries_string);
 
-               /*
-                * Check to see if the process actually exists
-                */
-               pidstr[len] = '\0';
-               post_pid = (pid_t) atoi(pidstr);
+       /* Parse string into list of identifiers */
+       if (!SplitIdentifierString(rawstring, ',', &elemlist))
+       {
+               /* syntax error in list */
+               pfree(rawstring);
+               freeList(elemlist);
+               ereport(LOG,
+                               (errcode(ERRCODE_SYNTAX_ERROR),
+                                errmsg("invalid list syntax for preload_libraries configuration option")));
+               return;
+       }
 
-               /* if pid < 0, the pid is for postgres, not postmatser */
-               if (post_pid < 0)
-               {
-                       is_postgres++;
-                       post_pid = -post_pid;
-               }
+       foreach(l, elemlist)
+       {
+               char       *tok = (char *) lfirst(l);
+               char       *sep = strstr(tok, ":");
+               char       *filename = NULL;
+               char       *funcname = NULL;
+               func_ptr        initfunc;
 
-               if (post_pid == 0 || (post_pid > 0 && kill(post_pid, 0) < 0))
+               if (sep)
                {
-
                        /*
-                        * No, the process did not exist. Unlink the file and try to
-                        * create it
+                        * a colon separator implies there is an initialization
+                        * function that we need to run in addition to loading the
+                        * library
                         */
-                       if (unlink(pidfile) < 0)
-                       {
-                               fprintf(stderr, "Can't remove pid file: %s\n", pidfile);
-                               fprintf(stderr, "The file seems accidently left, but I couldn't remove it.\n");
-                               fprintf(stderr, "Please remove the file by hand and try again.\n");
-                               return (-1);
-                       }
-                       fd = open(pidfile, O_RDWR | O_CREAT | O_EXCL, 0600);
-                       if (fd < 0)
-                       {
-                               fprintf(stderr, "Can't create pid file: %s\n", pidfile);
-                               fprintf(stderr, "Please check the permission and try again.\n");
-                               return (-1);
-                       }
+                       size_t          filename_len = sep - tok;
+                       size_t          funcname_len = strlen(tok) - filename_len - 1;
+
+                       filename = (char *) palloc(filename_len + 1);
+                       memcpy(filename, tok, filename_len);
+                       filename[filename_len] = '\0';
+
+                       funcname = (char *) palloc(funcname_len + 1);
+                       strcpy(funcname, sep + 1);
                }
                else
                {
-
                        /*
-                        * Another postmaster is running
+                        * no separator -- just load the library
                         */
-                       fprintf(stderr, "Can't create pid file: %s\n", pidfile);
-                       if (is_postgres)
-                               fprintf(stderr, "Is another postgres (pid: %d) running?\n", post_pid);
-                       else
-                               fprintf(stderr, "Is another postmaster (pid: %s) running?\n", pidstr);
-                       return (-1);
+                       filename = pstrdup(tok);
+                       funcname = NULL;
                }
-       }
 
-       sprintf(pidstr, "%d", pid);
-       if (write(fd, pidstr, strlen(pidstr)) != strlen(pidstr))
-       {
-               fprintf(stderr, "Write to pid file failed\n");
-               fprintf(stderr, "Please check the permission and try again.\n");
-               close(fd);
-               unlink(pidfile);
-               return (-1);
+               initfunc = (func_ptr) load_external_function(filename, funcname,
+                                                                                                        true, NULL);
+               if (initfunc)
+                       (*initfunc) ();
+
+               if (funcname)
+                       ereport(LOG,
+                                       (errmsg("preloaded library \"%s\" with initialization function \"%s\"",
+                                                       filename, funcname)));
+               else
+                       ereport(LOG,
+                                       (errmsg("preloaded library \"%s\"",
+                                                       filename)));
+
+               pfree(filename);
+               if (funcname)
+                       pfree(funcname);
        }
-       close(fd);
 
-       return (0);
+       pfree(rawstring);
+       freeList(elemlist);
 }