Caro-COOPS.org Discussion Board Discussion area for Caro-COOPS-related initiatives    FAQ   Search   Memberlist   Usergroups   Calendar   Register   Profile   Log in to check your private messages   Log in  building a new db          Caro-COOPS.org Discussion Board Forum Index    -> Tools, RDBMS / SQL    -> PostgreSQL, PostgreSQL View previous topic :: View next topic   Author Message cpurvis Joined: 24 Feb 2025 Posts: 255 Posted: Wed Sep 24, 2025 10:23 am    Post subject: building a new db Following http://caro-coops.org/resources/doc/postgis/x83.html Our .sql's are here: /usr/local/pgsql/share/contrib as postgres Code: # cd /usr/local/pgsql/share/contrib # createdb [yourdatabase] # createlang plpgsql [yourdatabase] # psql -d [yourdatabase] -f postgis.sql # psql -d [yourdatabase] -f spatial_ref_sys.sql Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         Caro-COOPS.org Discussion Board Forum Index    -> Tools, RDBMS / SQL    -> PostgreSQL, PostgreSQL All times are GMT - 5 Hours Page 1 of 1   Jump to:  Select a forum  Project --------- - Instrumentation - Collected data - Metadata - QA/QC - Website, bulletin board, and announcements - Storm Surge Model support - User applications - Hosted datasets   Tools ------ - Linux & hardware - Perl / PHP - Java / JSP - GIS (Geographic Information Systems)     MapServer   -----------   - MapServer     MapLab   --------   - MapLab     GRASS   ------   - GRASS     ESRI   -----   - ESRI     GIS Other   -----------   - Other   - RDBMS / SQL     PostgreSQL   ------------   - PostgreSQL     SQL Scripts   --------------   - SQL Scripts     Oracle   --------   - Oracle     DB Other   ----------   - Other   - PostGIS - Shell scripts - Cast-Net - XML / Data Standards - DODS / OPeNDAP - netCDF - LAS - Matlab - Zope - Links & documentation   Other ------ - Miscellaneous - System Administration - Project Management     Charlton   ----------   - Charlton       SEACOOS     ---------     - 2004 July finish PIC implementation (merged obs, wind & SST)     - 2004 July remote sensing layers for cached images     - 2004 July Data Visualization Workshop     - 2004 July implementation of wind field model     - 2004 July begin discussions w/ Brian re. particle trajectories     - 2004 August implement Modeling PIC (water level, wind, currents)     - 2004 August netCDF for water level (update data scout)     - 2004 August continue particle trajectory coordination and visualization     - 2004 September instantiate merged obs water level PIC     - 2004 September modeling PIC continues     - 2004 October implement changes from modeling PIC     - 2004 October implement changes from water level PIC     - 2004 November fall workshop       Jeremy   --------   - Jeremy     You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You can attach files in this forum You can download files in this forum Powered by phpBB 2.0.4 © 2001, 2002 phpBB Group