From 304aa339b20df9f9ba6f4d93175e05098f6fd1c1 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Tue, 22 May 2012 10:02:47 -0400 Subject: [PATCH] Prevent pg_basebackup when integer_datetimes flag doesn't match. Magnus Hagander, reviewed by Fujii Masao, with slight wording changes by me. --- src/bin/pg_basebackup/streamutil.c | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/src/bin/pg_basebackup/streamutil.c b/src/bin/pg_basebackup/streamutil.c index b12932fe3f8..0de6f54e415 100644 --- a/src/bin/pg_basebackup/streamutil.c +++ b/src/bin/pg_basebackup/streamutil.c @@ -75,6 +75,7 @@ GetConnection(void) const char **keywords; const char **values; char *password = NULL; + const char *tmpparam; if (dbhost) argcount++; @@ -157,6 +158,29 @@ GetConnection(void) free(values); free(keywords); + /* + * Ensure we have the same value of integer timestamps as the + * server we are connecting to. + */ + tmpparam = PQparameterStatus(tmpconn, "integer_datetimes"); + if (!tmpparam) + { + fprintf(stderr, _("%s: could not determine server setting for integer_datetimes\n"), + progname); + exit(1); + } + +#ifdef HAVE_INT64_TIMESTAMP + if (strcmp(tmpparam, "on") != 0) +#else + if (strcmp(tmpparam, "off") != 0) +#endif + { + fprintf(stderr, _("%s: integer_datetimes compile flag does not match server\n"), + progname); + exit(1); + } + /* Store the password for next run */ if (password) dbpassword = password; -- 2.39.5