Setting up postgres in ubuntu

postgres_instructions.MD

installing postgresql on ubuntu

Install postgres

sudo apt install postgresql postgresql-contrib

Set password for user postgres

sudo -i -u postgres

psql

ALTER USER postgres PASSWORD 'myPassword';

Create database 'bayou'

sudo -i -u postgres

createdb bayou

Add tables to database 'bayou'

sudo -i -u postgres

psql bayou

CREATE TABLE feeds( feed_id SERIAL PRIMARY KEY, name VARCHAR(255), public_key VARCHAR(255) UNIQUE, private_key VARCHAR(255) );

CREATE TABLE measurements( id SERIAL PRIMARY KEY, feed_id INT, temperature_c FLOAT, humidity_rh FLOAT, co2_ppm FLOAT, light_lux FLOAT, distance_meters FLOAT, pressure_mbar FLOAT, battery_volts FLOAT, rssi FLOAT, gps_lat FLOAT, gps_lon FLOAT, gps_alt FLOAT, node_id INT, next_hop INT, next_rssi FLOAT, distance_meters_1 FLOAT, distance_meters_2 FLOAT, distance_meters_3 FLOAT, temperature_c_1 FLOAT, temperature_c_2 FLOAT, temperature_c_3 FLOAT, voltage_1 FLOAT, voltage_2 FLOAT, voltage_3 FLOAT, aux_1 FLOAT, aux_2 FLOAT, aux_3 FLOAT, log VARCHAR(255),
timestamp TIMESTAMP DEFAULT NOW(), CONSTRAINT feed FOREIGN KEY(feed_id) REFERENCES feeds(feed_id) );

Add a new column to an existing database 'bayou'

sudo -i -u postgres

psql bayou

ALTER TABLE measurements RENAME COLUMN created TO timestamp;

Hi there.
Can I use the k30 code with a SenseAir S8?