Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suGMh-005TD6-EF for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 19:10:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1suGMg-00Dljp-BU for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 19:10:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suGMg-00DliQ-1R for pgsql-hackers@lists.postgresql.org; Fri, 27 Sep 2024 19:10:54 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1suGMc-001Oxw-IO for pgsql-hackers@postgresql.org; Fri, 27 Sep 2024 19:10:53 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-8349389f9b8so63683939f.0 for ; Fri, 27 Sep 2024 12:10:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727464250; x=1728069050; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=gHn4e4oyGA+I4OQdaUUCXMj5XtVOowoWjTsPk5qkHjQ=; b=FUM788F4UJeZGFG+fuOUlpzcCM3Ivdd1LqtV8kVu0ybngUOXilJknwmmxSQb9BMy5N BCUiVCTlNapxUFQ2It8CdwqUJAAn/sZuNemuTILw3ZasXaTFA2hKEVdDXJdWTPiVYbCZ 6F4N7cn/E19/NCfbJwqpUJc51YUTOjzq5fy44qBfXL6VqQm3Kzign17XucXZJxm4ICUD HntgElKRowIrKaTb2SxerexkanGJbMcyGJ/M8qw8Sm8SCuvA7qhgxS/7R4Ym1LAfym7H Kfw55eeLGuq2DzxqXPIyCWpA67ctziC9FpMlt0Vn0zD67SJpmk9FDr7/wIe2Gha5x5Vd 3gWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727464250; x=1728069050; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=gHn4e4oyGA+I4OQdaUUCXMj5XtVOowoWjTsPk5qkHjQ=; b=n3ntb2YM1l+r9lRsIeAL7eJJvyvqDFSRrLdXetkcrt8VkBpVN5p26YFyNn42f7Teuf Fj+c5UYEKESO0wWi4yQsHND+rsdhCg4Sezo5K4FU8w3lgUsWXLuthKn8kQdE1uEh3CeD jLDHFlsCz/yytV18lt3KTkd31Pbo5F/pXDXG49wHQJuWEy5ILKMDCxnRZxZZdjPH46PH XnAgoHPIj0gnN6sgBjyA2fNl8M7IMikupliZ7Jt5cYgBNmvwRmGfn/+fcyLp4zz5S8KR FPnN6x/7yQMDN57r0dd29RD1MHF9Y1uq787tBOdzlpLLulZjiH11PbL1LcOUuT4lxJ0L XRFQ== X-Forwarded-Encrypted: i=1; AJvYcCWY41ibWVJ/+Wt/+qQieB1UDRK9yfV22D1zMPxclUWEKZ51xhxqcByCUkzkGc3/pjNp9CXFEcq9kERSGO7H@postgresql.org X-Gm-Message-State: AOJu0YxBuO4RYlTvigrT+WxuHao14wyRIBicpjzMI2IRsOSvevptAM0/ R9TXSoHNZszaSrZt8VlRYnTuTVpbUma7qjh1HnYu21+fD5L8wJ3aHdUdHw== X-Google-Smtp-Source: AGHT+IHX4SXB8HLA/7qkoawRBciHkNqewGZSEZSp3G398peDEyJeofGFwXw1XTflyU21T+2N/yZrvQ== X-Received: by 2002:a05:6602:6015:b0:82a:31d4:1aab with SMTP id ca18e2360f4ac-834932741fdmr435886939f.14.1727464250461; Fri, 27 Sep 2024 12:10:50 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-834937194d6sm68833539f.40.2024.09.27.12.10.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 27 Sep 2024 12:10:49 -0700 (PDT) Date: Fri, 27 Sep 2024 14:10:47 -0500 From: Nathan Bossart To: Max Johnson Cc: Tom Lane , "pgsql-hackers@postgresql.org" Subject: Re: pg_ctl/miscinit: print "MyStartTime" as a long long instead of long to avoid 2038 problem. Message-ID: References: <3486094.1727210681@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 27, 2024 at 02:48:01PM +0000, Max Johnson wrote: > I think that it would be a good idea to include these fixes in the next > minor release. After working for a couple months on getting our embedded > systems 2038 compliant, it has become very apparent that 2038 will be a > substantial ordeal. Maximizing the number of systems that include this > fix would make things a little easier when that time comes around. Alright. I was able to back-patch it to v12 without too much trouble, fortunately. I'll commit that soon unless anyone else has feedback. -- nathan