Re: [GENERAL] Installing PostgreSQL in Debian
On Debian install PostgreSQL via APT. If you have APT installed: 1. Change to root. 2. Type apt-update. 3. Type apt-get install postgresql postgresql-client #2 updates your APT package list to the lastest-and-greatest. #3 installed the server and client applications. I'd read up on APT at the Debian home page: http://www.debian.org Regards, Jim > Hello, > > PostgreSQL is distributed as .RPM files. How do I > install this in Debian? > > Thanks > > > > > __ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings > - James Cradock, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] psql and mysql
A significant difference, and something that might be frustrating, is listing databases and database objects and describing tables. To list databases, type \l ...and hit RETURN. To list tables in the database you've logged in to, type \dt If you've got some familiarity with MySQL then querying database objects should be easy in PostgreSQL, altough PostgreSQL does obviously support some features and thus some commands not available in MySQL. There will be some learning there, possibly, but I think you'll find it easy. Type \? ...and press RETURN to see the full set of options. I definitely recommend reading the docs: http://www.postgresql.org/docs/current/static/app-psql.html Enjoy! Jim > Dear List, > I'm new to Psql and very eager to learn the differences between these two > RDBMS. > Any help is greatly appreciated. > Thanks > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > - James Cradock, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] psql and mysql
Clients aside, and as Christopher wrote, there are lots of differences between the two systems. PostgreSQL supports higher-end Enterprise-level RDBMS features. MySQL tends to be quicker. For example, and as just one example, PostgreSQL can store and handle GIS data through PostGIS. MySQL's OGC-compatible OGC support was introduced in the latest production-worthy release. Both MySQL and PostgreSQL are stable and easy to use and well supported. If you're trying to learn something, I definitely recommend reading the documentation. If you have some specific task in mind and think PostgreSQL might be the better fit, post a question to the list. Jim > Dear List, > I'm new to Psql and very eager to learn the differences between these two > RDBMS. > Any help is greatly appreciated. > Thanks > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > - James Cradock, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] psqsl -> remote db
First, makes sure the PostgreSQL database is listening for TCP/IP connections on the computer you're trying to connect to. On Mac OS X, run this command in the a terminal, i.e. Terminal.app: netstat -l You should see a line like this somewhere in the output: tcp6 0 0 *.5432 *.* LISTEN Second, the database server's pg_hba.conf likely needs to be configured to accept connections from remote users. This can be done to restrict connections from specific hosts (IP addresses), which isn't terribly practical, or by user and encrypted password. Search the PostgreSQL document site for "pg_hba.conf" for info. Third, if the database server is listening, and it is configured to allow you to connect, try connecting with psql: psql -h myhost.com -U me mydb "myhost.com" can be an IP address. Type "man psql" to see what the options mean. I hope this helps. Jim > I'm sorry, I'm sure I should be asking this someplace more general, but > apparantly the word 'port' is used in so many different contexts that a > google search turns up fruitless ;) > > I'm just trying to access a remote postgresql database on port 5432, > which does not appear to be open on the remote computer. I'm on a > MacOSX and cannot figure out for the life of me how to open up this > port on the computer. > > This is probably a unix question if anything, but any help would be > apprecaited. > > -Andrew > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings > - James Cradock, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] pg_dump
Bob, This command: pg_dump aurel ...should output the structure and contents of your "aurel" database to your screen SQL with comments. What version of PostgreSQL are you running and on what operating system? Jim > No joy > > pg_dump aurel > aurel.out > > Returns - > ERROR: syntax error at or near "pg_dump" at character 8 > > I've had a bit of trouble with the PostgreSQL system if that helps. > (access > violation with a reinstall) > > Bob > > - Original Message - > From: "Konrad Neuwirth" <[EMAIL PROTECTED]> > To: "Bob Pawley" <[EMAIL PROTECTED]> > Cc: "Postgresql" > Sent: Thursday, November 23, 2006 1:45 PM > Subject: Re: [GENERAL] pg_dump > > >>> To dump a database: $ pg_dump mydb > db.out" >>> The following - $ pg_dump aurel > aurel.out - gives me >>> "ERROR: syntax error at or near "$" at character 1" >>> What am I missing??? >> >> The $ character is there to indicate the prompt your shell gives you. >> If you leave it off at the beginning of your command, things should >> just run fine. >> >> Konrad >> >> ---(end of broadcast)--- >> TIP 5: don't forget to increase your free space map settings >> > > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > - James Cradock, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] pg_dump
Sorry. The command will output ... *AS* SQL with comments. > Bob, > > This command: > > pg_dump aurel > > ...should output the structure and contents of your "aurel" database to > your screen SQL with comments. > > What version of PostgreSQL are you running and on what operating system? > > Jim > >> No joy >> >> pg_dump aurel > aurel.out >> >> Returns - >> ERROR: syntax error at or near "pg_dump" at character 8 >> >> I've had a bit of trouble with the PostgreSQL system if that helps. >> (access >> violation with a reinstall) >> >> Bob >> >> - Original Message - >> From: "Konrad Neuwirth" <[EMAIL PROTECTED]> >> To: "Bob Pawley" <[EMAIL PROTECTED]> >> Cc: "Postgresql" >> Sent: Thursday, November 23, 2006 1:45 PM >> Subject: Re: [GENERAL] pg_dump >> >> To dump a database: $ pg_dump mydb > db.out" The following - $ pg_dump aurel > aurel.out - gives me "ERROR: syntax error at or near "$" at character 1" What am I missing??? >>> >>> The $ character is there to indicate the prompt your shell gives you. >>> If you leave it off at the beginning of your command, things should >>> just run fine. >>> >>> Konrad >>> >>> ---(end of >>> broadcast)--- >>> TIP 5: don't forget to increase your free space map settings >>> >> >> >> ---(end of broadcast)--- >> TIP 6: explain analyze is your friend >> > > > > - > James Cradock, [EMAIL PROTECTED] > > > > ---(end of broadcast)--- > TIP 9: In versions below 8.0, the planner will ignore your desire to >choose an index scan if your joining column's datatypes do not >match > - James Cradock, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
