I am about to start designing a postgreSQL database, my first db. Can anyone reccomend any useful literature that pertains to database design (not necessarily specific to postgre)? Im just looking to avoid common design mistakes and soak up some design principles.
I'd suggest taking a look at any DBMS Theory book and particularly read the chapters on "Normalization", because thats one important thing you will thing that will definitely help you to design a non-redundant and efficient database.
A good book for DBMS Theory is "Database Management Systems" by Ramakrishnan & Gehrke.