Difference between pages "Postgresql" and "Quota"

From WeWeWeb Wiki
(Difference between pages)
Jump to navigationJump to search
(Created page with "To add a user: create user <name> sysid <uid> encrypted password 'password' createdb; To convert to another encoding system: did a pg_dump iconv -f 8859_1 -t UTF...")
 
(Created page with "To enable quota in Linux: vi /etc/fstab LABEL=/ / ext3 defaults,usrquota,grpquota 1 1 mount -o remount / quotacheck -avmcug quotaon / edquota <us...")
 
Line 1: Line 1:
To add a user:
+
To enable quota in Linux:
  
  create user <name>
+
  vi /etc/fstab
  sysid <uid>
 
  encrypted password 'password'
 
  createdb;
 
 
 
To convert to another encoding system:
 
  
  did a pg_dump
+
  LABEL=/        / ext3    defaults,usrquota,grpquota        1 1
  iconv -f 8859_1 -t UTF-8
 
created new db with encoding UNICODE and reloaded- no errors upon reload
 
  
To dump a database:
+
mount -o remount /
  
  pg_dump dbname > outfile
+
  quotacheck -avmcug
  
To reload a datbase:
+
quotaon /
  
  psql dbname < infile
+
  edquota <user account>
or
 
psql -d database -f db.out
 
or
 
pg_restore -d newdb db.tar
 
  
 
To add the language 'plpgsql', login as postgres:
 
 
  createlang plpgsql <database>
 
 
To set trigger to update last_update column when modified:
 
 
  CREATE OR REPLACE FUNCTION update_lastupdate_column()
 
    RETURNS TRIGGER AS $$
 
      BEGIN
 
        NEW.last_update = now();
 
        RETURN NEW;
 
      END;
 
    $$ language 'plpgsql';
 
 
  CREATE TRIGGER update_customer_lastupdate BEFORE UPDATE
 
    ON customer FOR EACH ROW EXECUTE PROCEDURE
 
    update_modified_column();
 
 
----
 
----
 
Goto [[Linux]]
 
Goto [[Linux]]

Latest revision as of 12:15, 27 January 2022

To enable quota in Linux:

vi /etc/fstab
LABEL=/        /  ext3    defaults,usrquota,grpquota        1 1
mount -o remount /
quotacheck -avmcug
quotaon /
edquota <user account>

Goto Linux