Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-05 Thread Andrew L. Gould
On Sun, 5 Mar 2006 00:34:46 -0700 Brendan Duddridge [EMAIL PROTECTED] wrote: Hi, We're running PostgreSQL 8.1.3 on an Intel iMac at work and I also have it running just fine on my new MacBook Pro. No problems. Compiled as is out of the box using the instructions at http://

[GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-04 Thread Andrew L. Gould
I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? Thanks, Andrew Gould ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-04 Thread Andrew L. Gould
On Sat, 4 Mar 2006 19:34:49 -0800 Steve Atkins [EMAIL PROTECTED] wrote: On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote: I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? It's run fine

[GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Andrew L. Gould
I've been backing up my databases by piping pg_dump into gzip and burning the resulting files to a DVD-R. Unfortunately, FreeBSD has problems dealing with very large files (1GB?) on DVD media. One of my compressed database backups is greater than 1GB; and the results of a gzipped pg_dumpall

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Andrew L. Gould
On Monday 20 June 2005 09:53 pm, Tom Lane wrote: Andrew L. Gould [EMAIL PROTECTED] writes: I've been backing up my databases by piping pg_dump into gzip and burning the resulting files to a DVD-R. Unfortunately, FreeBSD has problems dealing with very large files (1GB?) on DVD media. One

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Andrew L. Gould
On Monday 20 June 2005 10:14 pm, Alvaro Herrera wrote: On Mon, Jun 20, 2005 at 09:28:51PM -0500, Andrew L. Gould wrote: I've been backing up my databases by piping pg_dump into gzip and burning the resulting files to a DVD-R. Unfortunately, FreeBSD has problems dealing with very large

Fwd: Re: [GENERAL] Updating a table on local machine from remote linux server

2005-02-04 Thread Andrew L. Gould
oops -- forgot to send this back to list. -- Forwarded Message -- Subject: Re: [GENERAL] Updating a table on local machine from remote linux server Date: Friday 04 February 2005 01:34 pm From: Andrew L. Gould [EMAIL PROTECTED] To: Art Fore [EMAIL PROTECTED] On Friday 04

[GENERAL] [OT] PostgreSQL and Namo's WebEditor

2005-02-02 Thread Andrew L. Gould
WebEditor has support for PHP and several databases, including support for ODBC and JDBC. Has anyone used it with PostgreSQL via ODBC? If so, do you recommend it? WebEditor is a Windows product; and current versions do not support PostgreSQL natively. Now that PostgreSQL is available for

Re: [GENERAL] [ODBC] ODBC (win32) X PostgreSQL(Linux)

2005-01-26 Thread Andrew L. Gould
On Wednesday 26 January 2005 07:07 am, Eric E wrote: Hi Fabricio, fbbsantos wrote: What details do you need? I need to know enough that if I sat down at your computer I could find the problem. For example, what language or application are you using? Are you using a DSN, or a DSN-less

Re: [GENERAL] Data entry - forms design or other APIs etc. - what is there?

2005-01-22 Thread Andrew L. Gould
On Saturday 22 January 2005 06:57 am, Chris Green wrote: On Fri, Jan 21, 2005 at 06:19:53PM -0600, Andrew L. Gould wrote: On Friday 21 January 2005 12:55 pm, Chris Green wrote: [snip question] Many languages have the capacity to access PostgreSQL databases including Python (with PyGreSQL

Re: [GENERAL] Best Linux Distribution

2005-01-21 Thread Andrew L. Gould
On Friday 21 January 2005 11:23 am, Bruno Almeida do Lago wrote: Any info about NetBSD? Bruno Recent OS benchmarks (nothing specific to PostgreSQL) were compared to FreeBSD 5.3 and posted at: http://www.feyrer.de/NetBSD/gmcgarry/ I don't know enough to apply the information to the

Re: [GENERAL] Data entry - forms design or other APIs etc. - what is there?

2005-01-21 Thread Andrew L. Gould
On Friday 21 January 2005 12:55 pm, Chris Green wrote: I'm working on an application for my own use and have been using knoda as a front end to postgresql but I need a bit more power and flexibility. I'm quite happy to get into relatively serious programming as I am a C++/Java programmer,

Re: [GENERAL] Best Linux Distribution

2005-01-20 Thread Andrew L. Gould
On Thursday 20 January 2005 09:20 pm, Joshua D. Drake wrote: [EMAIL PROTECTED] wrote: Does it have to be linux? I've never had as much success with PostGresql on linux as i have on FreeBSD 5.3 For XFS? I don't think you are going to have with FreeBSD and XFS. If IIRC (some freebsd person

Re: [GENERAL] Schema backup

2003-10-03 Thread Andrew L. Gould
On Tuesday 30 September 2003 09:15 pm, Greg wrote: I also have troubles with pg_dump. I have a database called 'shipping' and it has many tables(I populated them via a script). To dump the database I did these steps: su greg and then pg_dump /tmp/greg.dmp. A file greg.dmp gets created but

Re: [GENERAL] I need a SQL...

2003-09-11 Thread Andrew L. Gould
On Thursday 11 September 2003 06:25 am, Bjørn T Johansen wrote: I need to write a SQL that calculates the interval between a start time and a stop time. This is the easy part. The problem is that I only have the time part, i.e. no date, so how can I be sure to also calculate the interval if

Re: [GENERAL] Find overlapping time intervals, how?

2003-09-09 Thread Andrew L. Gould
On Tuesday 09 September 2003 02:29 pm, Holger Marzen wrote: Say, we have uptimes from several servers: Server up_from up_to -- --- --- s1 0:00 8:00 s1 10:0020:00 s1 22:0024:00 (would better be a timestamp with 0:00 and next day) s2

Re: [GENERAL] Cannot createdb

2003-09-07 Thread Andrew L. Gould
permissions? Let us know, Andrew L. Gould ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Excel 97 Export to Postgres

2003-08-26 Thread Andrew L. Gould
On Tuesday 26 August 2003 09:10 am, Raymond wrote: Need to export an existing M$ Access 97 database to Postgres. Tuples must be filtered as I am using sequences and other constraints. Help from anyone that has experience with this or know of 3rd party automation tools would be greatly

Re: [GENERAL] newbie and no idea

2003-08-18 Thread Andrew L. Gould
On Monday 18 August 2003 01:41 pm, Aaron wrote: On Mon, 2003-08-18 at 21:25, Pavel Stehule wrote: You can try If you know root's password, I just installed postgres from rpm and I didn't add passwords. I certainly don't know the postgres root password... maybe I should reinstall

Re: [GENERAL] Importing data

2003-08-14 Thread Andrew L. Gould
oops. I forgot to reply to the list. On Thursday 14 August 2003 06:45 pm, you wrote: On Thursday 14 August 2003 06:10 pm, you wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I have an old-ish Sybase dbms (SQL Anywhere v5.x) that does not offer a DUMP command. The only