Skip to main content

How to change timezone in PostgreSQL RDS server on AWS

I was facing some troubles the other day in a PostsgreSQL RDS created in N.Virginia AWS,  the RDS' timezone had to be synchronized in Colombia and as there are not any postgresql.conf in an AWS RDS in order to make that change you must connect to the database through the console, in my case I did something like this

username = postgres
database = postgres
endpoint = test.chwc4bq271vn.us-east-1.rds.amazonaws.com

psql -U postgres -h test.chwc4bq271vn.us-east-1.rds.amazonaws.com  -p 5525 -d postgres ( replace all these by your credentials and your endpoint )

after you set the password and you get to the prompt run this 

alter database postgres set timezone TO 'America/Bogota';

change the time zone by the one you need, or run this command to list the available zones:

select * from pg_timezone_names ;


after you have done the process, test it creating a table which you give it an id and it sets automatically the date


CREATE TABLE public."TimeTest"
(
   id integer, 
   time1 timestamp without time zone DEFAULT now(), 
   time2 timestamp with time zone DEFAULT now(), 
   CONSTRAINT "PK" PRIMARY KEY (id)
) 
WITH (
  OIDS = FALSE
);

and on that way, you can prove that the date is being saved according to the local time you have set
Labels:

Comments

Post a Comment

Popular posts from this blog

How to secure SpringBoot with SSL and Tomcat or Undertow

when we are going to take our applications to production mode, we must have an SSL certificate for the FrontEnd and   BackEnd too, in this case, our backend is a  SpringBoot which is using a tomcat embedded server. Terminology TLS vs SSL TLS is the successor to SSL. It is a protocol that ensures privacy between communicating applications. Unless otherwise stated, in this document consider TLS and SSL as interchangable. Certificate (cert) The public half of a public/private key pair with some additional metadata about who issued it etc. It may be freely given to anyone. Private Key A private key can verify that its corresponding certificate/public key was used to encrypt data. It is never given out publicly. Certificate Authority (CA) A company that issues digital certificates. For SSL/TLS certificates, there are a small number of providers (e.g. Symantec/Versign/Thawte, Comodo, GoDaddy, LetsEncrypt) whose certificates are included by most browsers and Op...
2 comments
Read more

How to deploy a VueJS App using Nginx on Ubuntu

There are thousands of blogs and websites out there explaining how to do a hello world and how to start with VueJS, but in this little post, I’m just going to be explaining how to do deploy a VueJs app after you have run the command through the CLI npm run build . So when you run the command npm run build a dist folder is created and that folder’s got the essential .js files to run our app, when we want to run our app on an Nginx server by default the vue-router is not going to work well so that Nginx does not come ready to work by default with a VueJs app This is basically for a Linux Ubuntu distribution if you’ve got any other Linux distribution just pay attention where is going to be set the www/html folder and the Nginx settings so that this is useful for any Linux distribution  Install and configure nginx sudo apt install nginx Double check to make sure the nginx service is running with command service nginx status, then open your browser and enter ...
1 comment
Read more

Printing using SpringBoot - cups4j

One of the easiest ways to print something from Java , in this case, using a SpringBoot Java Api Rest is with CUPS . Let's assume you've set up your CUPS server up and running, add to your pom.xml file this dependency      < dependency >      < groupId > org.cups4j </ groupId >      < artifactId > cups4j </ artifactId >      < version > 0.7.6 </ version > </ dependency > now at this imports to import  java.io.FileInputStream; import  java.io.FileNotFoundException; import  java.net.URL; import  java.util.HashMap; import  java.util.List; import  org.cups4j.CupsClient; import  org.cups4j.CupsPrinter; import  org.cups4j.PrintJob; import  org.cups4j.PrintJobAttributes; import  org.cups4j.PrintRequestResult; import  org.cups4j.WhichJobsEnum; add this method to prin...
Post a Comment
Read more