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

2008-03-03 Thread Steven De Vriendt
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

2008-02-28 Thread Steven De Vriendt
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 ?

2007-06-04 Thread Steven De Vriendt
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 conn

[GENERAL] Can i run pg_ctl under Administrator account ?

2007-03-09 Thread Steven De Vriendt
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: expl

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

2007-03-07 Thread Steven De Vriendt
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) O

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

2007-03-07 Thread Steven De Vriendt
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 broadcast)---

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

2007-01-25 Thread Steven De Vriendt
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 instal

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

2007-01-25 Thread Steven De Vriendt
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 hel

[GENERAL] PostgreSQL 8.1: createdb: xflush error ?

2007-01-23 Thread Steven De Vriendt
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