BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  PostgreSQL on windows platform using Delphi 7          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Patrick Guest Posted: Wed Sep 03, 2003 2:47 pm    Post subject: PostgreSQL on windows platform using Delphi 7 Hi! Is anyone using PostgreSQL on a windows platform with Delphi 7 What are your experiences with this setup ? (Stability, ease of installation, administration ...) What version of PostgreSQL are you using and is it using Cygwin ? What connection componants are you using ? Thanks for any comments. Pat. Back to top Monteiro Guest Posted: Fri Sep 05, 2003 1:49 am    Post subject: Re: PostgreSQL on windows platform using Delphi 7 Patrick wrote: Quote: Hi! Is anyone using PostgreSQL on a windows platform with Delphi 7 What are your experiences with this setup ? (Stability, ease of installation, administration ...) What version of PostgreSQL are you using and is it using Cygwin ? What connection componants are you using ? It will work under Windows with Cygwin, but performance and administration ins't that good; keep it running on Linux/Unix. Version 7.5, which should be released in a few months, wil add native Win32 support. About components, I recommend the dbExpress driver from Vita Voom: http://www.vitavoom.com - it's fast, clean and rock solid. Nothing on the market matches that driver (and I've tested them all ). Monteiro Back to top Patrick McLaughlin Guest Posted: Fri Sep 05, 2003 2:42 am    Post subject: Re: PostgreSQL on windows platform using Delphi 7 Thanks for the reply, What's do you think ok zeos componants ? Sorry but my boss is bent on a windows version with zeos and I am trying to stear him right!!! Thanks Pat. "Monteiro" <monteiro (AT) ime (DOT) usp.br> wrote Quote: Patrick wrote: Hi! Is anyone using PostgreSQL on a windows platform with Delphi 7 What are your experiences with this setup ? (Stability, ease of installation, administration ...) What version of PostgreSQL are you using and is it using Cygwin ? What connection componants are you using ? It will work under Windows with Cygwin, but performance and administration ins't that good; keep it running on Linux/Unix. Version 7.5, which should be released in a few months, wil add native Win32 support. About components, I recommend the dbExpress driver from Vita Voom: http://www.vitavoom.com - it's fast, clean and rock solid. Nothing on the market matches that driver (and I've tested them all ). Monteiro Back to top Alan Guest Posted: Tue Nov 11, 2003 12:51 am    Post subject: Re: PostgreSQL on windows platform using Delphi 7 Where to download PostGres windows version ? "Patrick McLaughlin" <pat_mcl_ (AT) videotron (DOT) ca> wrote Quote: Thanks for the reply, What's do you think ok zeos componants ? Sorry but my boss is bent on a windows version with zeos and I am trying to stear him right!!! Thanks Pat. "Monteiro" <monteiro (AT) ime (DOT) usp.br> wrote in message news:3F57EBC0.4010709 (AT) ime (DOT) usp.br... Patrick wrote: Hi! Is anyone using PostgreSQL on a windows platform with Delphi 7 What are your experiences with this setup ? (Stability, ease of installation, administration ...) What version of PostgreSQL are you using and is it using Cygwin ? What connection componants are you using ? It will work under Windows with Cygwin, but performance and administration ins't that good; keep it running on Linux/Unix. Version 7.5, which should be released in a few months, wil add native Win32 support. About components, I recommend the dbExpress driver from Vita Voom: http://www.vitavoom.com - it's fast, clean and rock solid. Nothing on the market matches that driver (and I've tested them all ). Monteiro Back to top Paul Linehan Guest Posted: Tue Nov 11, 2003 1:02 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 [email]NOSPAMalan_pltse (AT) yahoo (DOT) com.au[/email] says... Quote: Where to download PostGres windows version ? Go to www.postgresql.org The problem with PostgreSQL is that it was designed for real operating systems (no flames please), and thus, doesn't work well under Windows - you have to get cywin for it to work. I tried this and it's quite frankly a mess - wait until 7.5 when they say that they will have a native Windows version. Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. Back to top Ray Marron Guest Posted: Tue Nov 11, 2003 5:39 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 "Paul Linehan" <paul (AT) not (DOT) a.chance.ie> wrote [SNIP] Quote: you have to get cywin for it to work. Only if you want the latest version. This version (7.2.1) runs natively on Windows (best on NT+ so you can use the service): http://techdocs.postgresql.org/guides/InstallingOnWindows -- Ray Marron Back to top Paul Linehan Guest Posted: Tue Nov 11, 2003 7:44 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 marron+delphi (AT) cableaz (DOT) com says... Quote: you have to get cywin for it to work. Only if you want the latest version. This version (7.2.1) runs natively on Windows (best on NT+ so you can use the service): I am sure that I saw on the Postgres site that it was (something like) "inadvisable" to run it on Windows - again IIRC, it was by one of their gurus. Quote: http://techdocs.postgresql.org/guides/InstallingOnWindows From the site. "Following are step by step instructions for setting up the beta version of the PeerDirect native Windows port of PostgreSQL 7.2.1, called UltraSQL. These steps were successful on Windows 2000 but may also work on other versions of Windows. Thanks for the comments and feedback. If anyone has any further suggestions please let me know." Note that it's a beta. Thanks for the link though! Downloading as we speak! Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. Back to top Martin Brekhof Guest Posted: Tue Nov 11, 2003 8:13 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 http://www.commandprompt.com/ http://www.postgresql.org/news/127.html http://www.dbexperts.net/postgresql hth, Martin Back to top Ray Marron Guest Posted: Tue Nov 11, 2003 8:20 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 "Paul Linehan" <paul (AT) not (DOT) a.chance.ie> wrote .... Quote: I am sure that I saw on the Postgres site that it was (something like) "inadvisable" to run it on Windows - again IIRC, it was by one of their gurus. Obviously, the environment it was originally written for will perform better. I hear that some not-too-distant future version will support Windows "out of the box". I haven't noticed anything terribly lacking in the Windows port, except for the older Pg version - no ALTER TABLE DROP COLUMN! I've run it on NT4 and 2000 Server. Installation was very easy. -- Ray Marron Back to top Paul Linehan Guest Posted: Tue Nov 11, 2003 10:14 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 [email]me (AT) privacy (DOT) net[/email] says... Quote: I am sure that I saw on the Postgres site that it was (something like) "inadvisable" to run it on Windows - again IIRC, it was by one of their gurus. Quote: Obviously, the environment it was originally written for will perform better. I hear that some not-too-distant future version will support Windows "out of the box". They did have it promised for 7.4 (I was salivating!), but they've pushed that out to 7.5 (damn - another 6 months to a year at least). Quote: I haven't noticed anything terribly lacking in the Windows port, except for the older Pg version - no ALTER TABLE DROP COLUMN! I've run it on NT4 and 2000 Server. Installation was very easy. OK, maybe you can help me. Machine name is Paulie, my user name on the machine is paul (administrator level). I ran the install, and everything seems to be working. However, when I type psql at the command prompt I get psql: FATAL 1: Database "Paul" does not exist in the system catalog. I have created a user posgres - should I use this instead? There is something about not being able to run PosgreSQL as an Admin, isn't there? Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. Back to top Ray Marron Guest Posted: Wed Nov 12, 2003 2:36 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 "Paul Linehan" <paul (AT) not (DOT) a.chance.ie> wrote .... Quote: psql: FATAL 1: Database "Paul" does not exist in the system catalog. I have created a user posgres - should I use this instead? There is something about not being able to run PosgreSQL as an Admin, isn't there? The only restriction I know of is that the instructions say that the account that runs the service must be the same as the user that runs INITDB. Other than that, do "CREATEDB paul" or try connecting to template1 first (psql -Upaul template1) and creating another database from there. -- Ray Marron Back to top Paul Linehan Guest Posted: Wed Nov 12, 2003 3:45 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 [email]me (AT) privacy (DOT) net[/email] says... Quote: psql: FATAL 1: Database "Paul" does not exist in the system catalog. I have created a user posgres - should I use this instead? There is something about not being able to run PosgreSQL as an Admin, isn't there? Quote: The only restriction I know of is that the instructions say that the account that runs the service must be the same as the user that runs INITDB. Quote: Other than that, do "CREATEDB paul" or try connecting to template1 first (psql -Upaul template1) and creating another database from there. I seem to have created two dbs (paul and Paul) - it only started to respond (i.e. C:> psql dropped me into the PostgreSQL command line environment) after I had created the one called "Paul". I'm a bit puzzled as to why one has to create a db with one's own username before one can start to use the system. Anyway, that seems to have been a help - I'll see what I can make of it from here - thanks. Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. Back to top Paul Linehan Guest Posted: Wed Nov 12, 2003 3:47 pm    Post subject: Re: PostgreSQL on windows platform using Delphi 7 [email]me (AT) privacy (DOT) net[/email] says... Quote: Other than that, do "CREATEDB paul" or try connecting to template1 first (psql -Upaul template1) and creating another database from there. Hmmm.... the response of the PGAdmin III tool has changed also - it now says that the db must be at least 7.3 to connect - rats! That means that I'll have to download an older version this evening! Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.