After running the instance and making sure that all the librarys are installed
Please run :
psql -U postgres
CREATE USER tali WITH PASSWORD 'pass'
CREATE DATABASE Tcount WITH OWNER tali ENCODING 'utf-8';
If you got an error for utf-8 Please run the following scripts:
First, we need to drop template1. Templates can’t be dropped, so we first modify it so t’s an ordinary database:
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
Now we can drop it:
DROP DATABASE template1;
Now its time to create database from template0, with a new default encoding:
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
Now modify template1 so it’s actually a template:
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
Now switch to template1 and VACUUM FREEZE the template:
\c template1
VACUUM FREEZE;
Then create the DATABASE
CREATE DATABASE tcount WITH OWNER tali ENCODING 'utf-8';
go to tcount database
psql -U tali tcount
DELETE TABLE Tweetwordcount;
CREATE TABLE Tweetwordcount (id serial PRIMARY KEY, word TEXT NOT NULL,count INT NOT NULL);
exit from postgres or open a new terminal
make a projetc of EX2Twwetwordcount
sparse quick EX2Twwetwordcount
go to the directory of EX2Twwetwordcount
replace the topology and spouts and bolts
sparse run