Re: [GENERAL] Connect to postgres from a dynamic IP

yes, it is possible if you use a service like dyndns: http://www.dyndns.com/ to convert your dynamic ip. If you use this service you connect your dynamic ip to a hostname, which is dynamically updated by this service. after that you can change your windows hosts file to add the hostname you have

[GENERAL] syntax errors at line 1 when executing every command

Hi list, I'm using the latest postgreSQL with the lastest postgis. When executing every command I want to use, I get the following error message: postgis=# createdb; ERROR: syntax error at or near createdb LINE 1: createdb; ^ I can use psql to reach my database, but after that I'm

[GENERAL] Can someone have a look at my pg_hba.conf file ?

Hi, I'm trying to reach my postgres database via a remote connection. Yet my connection is refused when I try to do that. I'm using Ubuntu Feisty Following lines are now in my pg_hba.conf-file: # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket

[GENERAL] Can i run pg_ctl under Administrator account ?

Using Windows Xp I want to start pg_ctl as administrator. Reason for that I'm using Apache Tomcat and I can't seem to start that without Administrator privilges. Can someone tell me how do that ? Regards, Steven ---(end of broadcast)--- TIP 6:

[GENERAL] How to use pg_resetxlog if data directory is in c:/Program Files ?

Hi all, Got this kind of silly question. I'm trying to use pg_resetxlog. Problem is the path to c:/Program Files//data doesn't get reached, probably (space in between). How can I resolve this in order to run this command ? Regards, Steven ---(end of

Re: [GENERAL] How to use pg_resetxlog if data directory is in c:/Program Files ?

Thank you very much Shoaib, that worked fine ! Regards, Steven On 3/8/07, Shoaib Mir [EMAIL PROTECTED] wrote: Try using something like this -- Program Files/PostgreSQL/data (that is with quotes for using spaces) -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 3/8/07, Steven De

[GENERAL] libeay32.dll ssleay32.dll in system PATH

Hi, When I try to install PostgreSQL8.2 I get this error message: Incompactibel version of openssl detected in system path. when you remove libeay32.dll ssleay32.dll in your system path postgres will install a newer version... I've looked in my PATH but I can't seem to find it, can anyone

Re: [GENERAL] libeay32.dll ssleay32.dll in system PATH

solved :-) thx On 1/25/07, Magnus Hagander [EMAIL PROTECTED] wrote: Check your system, system32 and winnt directories. /Magnus --- Original message --- From: Steven De Vriendt [EMAIL PROTECTED] Sent: 1-25-'07, 11:37 Hi, When I try to install PostgreSQL8.2 I get this error

[GENERAL] PostgreSQL 8.1: createdb: xflush error ?

Hi, I'm trying to make a new database, yet when I try to do this I get the following error: ERROR: xlog flush request 0/827520 is not satisfied --- flushed only to 0/80D7B8 CONTEXT: writing block 5 of relation 1663/16893/1259 Can someone give me a clue of what it means ? Regards, Steven