Have you verified that your remote PostgreSQL server access is trusted to execute certain commands? Pls check your server's postgresql.conf and pg_hba.conf. Hope this helps.
On 10/26/06, Peter Santiago <[EMAIL PROTECTED]> wrote:
Hi, I'd like to post a question for all of you postgresql gurus. In a new installation of postgresql, is it SOP to add a database called postgres? My situation is this. I require connecting to a remote postgresql server and create/access databases remotely. When I use the createdb command on the local machine like so: createdb -U sa -h 192.168.1.1 testdb, this will return an error that the database postgres is not found. The sa user is granted ability to breate databases. The maddening thing about this, is when you execute the same command on the local machine with a Postgresql server running, just createdb -U sa testdb, the database gets created with nary a squeak. The question is why is database postgres is required to be present on the remote Postgresql server, before a regular user, with create database permission, can create a database? -- Peter Santiago [EMAIL PROTECTED] My website: www.psinergybbs.com My spamtrap address: [EMAIL PROTECTED] _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
-- Tito Mari Francis H. Escaño Computer Engineer and Free Software Proponent _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
