Strange, I have had postgresql from version 7.0 to
8.1 running just fine on OS X. The only thing I ever
have to do is to install an up to date version of
bison and readline.
What version of OS X is this. It could be a problem
with darwinports.
Ted
--- Konstantin Pavlovsky
<[EMAIL PROTECTED]> w
So my problem is that the program EOModeler is forcing
the schema-qualified constraint. I will filed a bug
report with Apple Unfortunitily, I believe that
the product has been deprecated I have yet to get
eclipse with "entity modeler" working correctly to see
what it does the the name space
try:
select 30/50::float;
?column?
--
0.6
(1 row)
Ted
--- Jeferson Kasper <[EMAIL PROTECTED]> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3230
> Logged by: Jeferson Kasper
> Email address: [EMAIL PROTECTED]
> PostgreSQL version:
10.5.1 a new install on a separate HD. Xcode 3 was
installed fresh (as the HD was freshly formatted)
intel (quad processor)
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> "ted petrosky" <[EMAIL PROTECTED]> writes:
> > PostgreSQL version: 8.3RC2
> > Operating system: os x
> > Description:
so I just tried uninstalling and reinstalling
Xcode3 same result.
will it help to see the actual logs?
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> "ted petrosky" <[EMAIL PROTECTED]> writes:
> > PostgreSQL version: 8.3RC2
> > Operating system: os x
> > Description:can not 'make'
>
with webobjects...
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > when I check the results/float4.out I see:
> > psql: FATAL: sorry, too many clients already
>
> Hah. Check what initdb set max_connections to,
I just upgraded to system 10.2.2 for Mac OSX. I saw in
the documentation that they have added a new
Journaling File System so on a lark I turned it on.
I see that when postgresql is starting up it now takes
it quite a while (from about 2 seconds to 12-15
seconds). I don't see anything else 'weird'
There is a problem with the 'make' of 7.2.x in 10.2
There is a fix that requires commenting out a few
lines.
search the 'bugs' area and you will find the thread.
Ted
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> You should try 7.3beta. It will work on that OS.
>
>
--
I just downloaded beta 5 and ran through a stock
config and make. make check comes up with 1 failure
listed as ignored..
parallel group (16 tests): select_distinct_on
transactions random select_having subselect
select_into select_distinct portals arrays union case
select_implicit hash_index aggre
I seem to have a little problem here. I have a pg_dump
file that I created with pg 7.1.3 that I just can not
seem to get to load into 7.2.3.
I know that I used the dump file to migrate to 7.2.3
originally, however in upgrading to osx 10.2.2 it
doen't seem to work when I try to use psql:
psql dbn
So, as I said I have a problem restoring data created
with pg_dump. Here is something interesting.
The pg_dump file contains a couple of tables. Some of
them are working. If I go to the line that psql is
telling me is failing, I find the commands to begin
recreating the table:
COPY "fcopenjobs" F
Tom,
I have checked the dump file with hexedit and find
that the lines end with '0A' hex. Only one character.
What is strange is that I have multiple tables, some
of them are going in fine.
Ted
-- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTEC
I've just finished the install of 7.3 release on mac
OSX 10.2.2. I notice that initdb will permit me to
init a directory for use, then when running postmaster
using the directory I get a fatal error:
FATAL: invalid value for option 'LC_TIME': 'en'
Shouldn't initdb check and not init with this lo
I've just finished the install of 7.3 release on mac
OSX 10.2.2. I notice that initdb will permit me to
init a directory for use, then when running postmaster
using the directory I get a fatal error:
FATAL: invalid value for option 'LC_TIME': 'en'
Shouldn't initdb check and not init with this
I will send the bug report copying what is said here
to Apple.
I copied and pasted the error message here so it did
not say 'en_US'.
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I've just finished the ins
Is this a bug or is this how it is supposed to work?
postgresql 7.3 (release)
mac osx 10.2.2
select for update
I have two terminal sessions open with psql running
and talking to the same db.
in window 1 : begin;
in window 1 : select column1 from table where column1
= 'text' for update;
in wind
This isn't all my problem...
I was going through tutorials, and I typed in the
example for inheritance. I had a typo that did not
throw an error and I think it should.
i created the tables from the cities, capitals example
and then tried to insert.
test-db=# insert into capitals (name, populatio
There is a problem with mac osx in regard to locale. A
bug report was submitted to apple, they (apple)
acknowledged the bug and said it would be addressed in
a future version.
End result... when you initdb you need to use locale =
C. I forgot the exact syntax just look at the docs.
initdb --local
I have see this problem since 7.3.1
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Kenji Sugita <[EMAIL PROTECTED]> writes:
> > Libpq.a still not ranlibed after installation. It
> causes link error on some
> > platform likes as Mac OS X for PostgreSQL 7.3.3.
>
> I see no problem when I test on OS
Please help with a mac osx installation... I had
installed 7.3.4 on osx 10.2.6 some months ago. it was
a painless installation. I responded to someone on the
apple help list about installing. this person was
having a problem with the make stage. I didn't think
to retry making on my system.
I did.
7;, needed by
`pg_dump'. Stop.
make[2]: *** [all] Error 2
any ideas... do you have an ETA for the return of your
mac... we need you
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > any ideas... i believe the problem lies w
I think this is what you wanted.
select to_char('03/06/1973'::date,'dd/mm/');
you were casting the string to a date and returning a
date. so it would return it in a format that your
system is set to return.
agencysacks=# select
to_char('03/06/1973'::date,'dd/mm/');
to_char
If anyone is interested, the only solution I have
found is not use it. I refer to the december 2002
update to OS X developers tools which includes the gcc
3.3 compiler.
the solution if you have installed it is to set your
mac back to 3.1.
su
gcc_select 3.1
su postgres
./configure (with what y
I thought I would try to make 7.4beta2 on my os X
machine. I used the default ./configure then make.
make says everything is ok to install so I tried a
make check.. this is my error log.
gcc is set for 3.1
os X 10.2.6.
I don't know if this is just a 'make check' problem or
if what I have is NFG.
Contrats.
Macintosh OS X 10.2.6
gcc 3.1
make check completes with 0 (zero) errors...
Ted
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---(end of broadcast)-
Tom,
I was totally unable to get 3.3 to work. Even with the
switch. My method is to switch with the script to 3.1
to make postgresql. (for mac OS X)
sudo gcc_select 3.1
works fine through 7.4 beta 3.
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Hunter Hillegas <[EMAIL PROTECTED]> writes:
>
Just to let you know... a few weeks ago I submitted to
Apple the problem of not being able to 'make'
postgresql. Here is the response from them...
Ted
--- [EMAIL PROTECTED] wrote:
> Date: Mon, 22 Sep 2003 22:40:39 GMT
> To: [EMAIL PROTECTED]
> Subject: Re: 3412624: can not 'make' postgresql
> Fro
I am not sure but i thought I read something of this
problem and maybe its not a problem but my
understanding.
There are only 30 days in september however I can not
seem to make a query that asks for october 1.
proofduedate is time stamp with zone
maybe this is the problem but I am a little los
10:26:57 -0700,
> Theodore Petrosky <[EMAIL PROTECTED]> wrote:
> > I am not sure but i thought I read something of
> this
> > problem and maybe its not a problem but my
> > understanding.
> >
> > There are only 30 days in september however I can
> not
> >
n's Magic | test the notify stuff |
Wed Oct 01, 2003 01 pm
10086 | Ellen's Magic | test of notify|
Wed Oct 01, 2003 04 pm
10082 | Leading Hotels | Atlanta Herald|
Wed Oct 01, 2003 04 pm
10088 | Leading Hotels | NYT |
Wed Oct 01, 2003 04 pm
(7 rows)
', 'DD Month HH24:MI');
to_timestamp
-
0003-10-01 23:59:00
(1 row)
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I am sorry, I wasn't clear... when i refered to
> > 01 October
HH24:MI');
to_timestamp
2003-10-02 23:59:00-04
(1 row)
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I am sorry, I wasn't clear... when i refered to
> > 01 October 2003
> &
So really if I had started coding this in a month
other than September I would have seen the problem
sooner...
Thanks for the help
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I should have sent this... it
I just download 7.4 beta 4. it makes and make check on
mac os x 10.2.8 with gcc 3.3 just fine.
Ted
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---(end of broadcast)-
I am sorry to post this here but... (i did post in the
odbc section but I don't think there are many osxers
there).
i am having a problem with mac osx and psqlODBC. If
there is anyone that is experienced with osx and odbc
and is willing to help, please respond off list.
i really need this and ca
I just downloaded and installed RC1 (7.4) on OSX 10.3.
Everything went smoothly for the config. make and
install.
while reloading the data (from pg_dump in 7.3) I
inadvertently screwed up. Or maybe not...
my dump file was as1.out so I...
psql < as1.out
I knew it was wrong the moment after I hi
Tomas Szepe <[EMAIL PROTECTED]> wrote:
> On Nov-11 2003, Tue, 11:38 -0800
> Theodore Petrosky <[EMAIL PROTECTED]> wrote:
>
> > I just downloaded and installed RC1 (7.4) on OSX
> 10.3.
> > Everything went smoothly for the config. make and
> > insta
This is the initdb.log for my OS X 10.3.1 system.
the install was made with.
./configure
make
make check.
Ted
Running in noclean mode. Mistakes will not be cleaned
up.
The files belonging to this database system will be
owned by user "postgres".
This user must also own the server process.
Th
72160
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > FATAL: could not create shared memory segment:
> Cannot
> &g
cs that this is
necessary at least as far as 10.3.1 (osx).
Ted
--- Neil Conway <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > After about two hours of hunting pecking and
> anything
> > else I found where you control t
BTW,
I find it difficult to understand exactally what
reasonable values are.
Is it possible in the docs to explain a little what
these values should be. Or how to calculate them. I
felt totally in the dark. If I hadn't fallen across an
email on one of the sites that suggested values, I
think I w
After reading the HISTORY file with the new 7.4, I
happened across the thread-safe with libpq stuff. As I
am using this in my OS X app I thought I would add it
in. (Not that I thought that I needed it, it was more
for fun..)
I got the following error on configure:
checking for pthread.h... yes
c
OS X 10.3.1 postgres 7.4
make check...
make[4]: Nothing to be done for `all'.
All of PostgreSQL successfully made. Ready to install.
make -C src/test check
make: *** src/test: No such file or directory. Stop.
make: *** [check] Error 2
BTW my other message about thread safe was also OS X
10.3.1
I'm on Mac OS X 10.3.2
gcc --version
gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build
1495)
cannot ./configure --enable-thread-safety
I don't know what to send to youse guys...
checking for pthread.h... yes
configure: error:
Cannot enable threads on your platform.
Please report your platform
I seem to be missing something on Mac OSX.
./configure --with-rendezvous
make
All of PostgreSQL successfully made. Ready to install.
beautiful... so I tried make check
[symcom:~/software/postgresql-7.4] postgres% make
check
All of PostgreSQL successfully made. Ready to install.
make -C src/test
Woops... my bad..
I had downloaded the 'base' distro. There was no
'test'.. I downloaded the correct one and everything
is OK.
BTW, Tom.. do you know how to enable thread-safety in
OSX?
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL P
I don't see the problem... you are specifying the 66th
day of the 55th month in the year . just a cursory
glance says that 48 months is 4 years... that gives
the year as 5559. try your example with real numbers
(unless these are real)
select to_date('13122003','ddmm');
to_date
--
you will have to edit the file called 'rc' in the top
level etc folder..
in the terminal type
cd /etc
sudo pico rc
(you will be asked for an administrator password)
scroll down 2 to 3 pages and find the section like
this
# System tuning
sysctl -w kern.maxvnodes=$(echo $(sysctl -n
hw.physmem) '3
recently I was playing around with psql and tried to
log onto a postgresql server so I tried...
psql -h 10.0.1.233 dbname
and to my suprise, i was in and able to issue
commands. what is 'bothering' me is that I was not
asked for a password. in defence of the system, I was
on a mac os x box logged
Just a heads up for anyone that uses os x. the update
to 10.3.3 dings the '/etc/rc' file.
if you are setting the system tunings there, they will
be set back to the defaults.
does anyone have a better place that will survive a
system update?
Ted
__
Do you Yahoo!?
You must edit the file /etc/rc ( sudo pico /ect/rc )
find the system tuning section and change as follows:
sysctl -w kern.sysv.shmmax=167772160
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536
warning... this change w
Sounds like your original installation of RH had an
installation of postgres in a different location. so
now you have two and the other one is the one you are
seeing when you start up.
Ted
--- John Muzzatti <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've downloaded and installed PostgreSQL 7.4 onto
Interesting
If I reverse the order it works...
agencysacks=# SELECT CAST('01.01.2004 10:00:00' AS
TIMESTAMP) + (CAST('01.01.2004 10:01:00' AS TIMESTAMP)
- CAST('01.01.2004 10:00:00' AS TIMESTAMP)) as answer;
answer
-
2004-01-01 10:01:00
(1 row)
However you
7.4.2 gives it like this:
testbed=# select replace('test %%400%% result',
'result', 'ok');
replace
-
test %%400%% ok
(1 row)
testbed =# select replace('test %400% result',
'result', 'ok');
replace
---
test %400% ok
(1 row)
Ted
-- Nicolas Bottar
I just updated to OS X 10.3.5 and Xcode 1.5
my configure was
./configure --with-rendezvous
make
this is the error I get with 'make check'. I don't
know if it's my fault but i read all the install docs
and didn't see that I need to do anything special for
the 'make check'...
dyld:
/Users/postgr
I hope we are okay with this... I tried your path and
it didn't work ... I am in bash so I did:
export env
DYLD_LIBRARY_PATH=/Users/postgres/software/postgresql-8.0.0beta1/src/interfaces/libpq
Let me know if there is something else I could try.
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Ada
This was my bad I thought I did what you suggested
however looking through the terminal history I see
that I left out part of the path. The export env works
beautifully for me.
Thanks,
Ted
--- Adam Witney <[EMAIL PROTECTED]> wrote:
>
> I'm not sure I understand you, but you are saying
> t
Can someone shed some light on the thread safety
switch. I am using PostgreSQL on mac os x. I have made
and installed from 7.2 through 8.0b. I now see this
feature of thread safety and I don't understand why I
would need it.
I have tried:
./configure --with-rendezvous --enable-thread-safety
I ge
Did I miss something that I should so to make 8.0beta2
for Mac OS X. I read the README and install and I see
no specific instructions for OS X.
Here is the info where the make fails.
OS X 10.3.5
gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build
1666)
What else can I send to you?
Ted
gcc -no-
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > Did I miss something that I should so to make
> 8.0beta2
> > for Mac OS X.
>
> Last time I tried it (which was a couple weeks
> back), our CVS tip built
> perfe
How's this one...
I realized that the machine I was testing on was
running '[EMAIL PROTECTED]'.. so I quit it.. Lo and behold
beta 2 compiled and made (with make check) just fine.
Thanks
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECT
You already have the answer. Of course the solution
has been described on the lists a few times. Open the
file /etc/rc in pico (don't forget to sudo) ( sudo
pico /etc/rc ). scroll down to the system tuning
section and change to look like this.
# System tuning
sysctl -w kern.maxvnodes=$(echo $(sysc
Hi all,
I just tried the newest beta (3) and for the first
time I am getting multiple errors in 'make check'.
this is my configure line...
./configure --with-rendezvous --enable-thread-safety
--disable-shared
I inserted the --disable-shared from a recomendation
to not create the shared librari
-shared
You can build without getting the dylib.
- Scott
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I just tried the newest beta (3) and for the first
> > time I am getting multiple errors in 'make check&#x
Hi guys,
I am trying to make RC 1 on OS X.
My setup is:
OS X 10.3.2
gcc --version
gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build
1666)
Copyright (C) 2002 Free Software Foundation, Inc.
./configure --with-rendezvous --enable-thread-safety
then make..
here is my error...
gcc -no-cpp-pr
must have been a bad unarchive. I gnuzip'd and un
tar's again and everything made ok. The regression
test are all ok..
thanks,
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > ../../Unicode/utf8_to_euc_cn.map:4231:
I just found the time to try 8.0RC2 on OSX and I have
a problem with 'make check'.
Here is my configure..
./configure --disable-shared --with-rendezvous
--enable-thread-safety
make then make check
== creating temporary installation
==
pg_regress: installation fa
t;[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I just found the time to try 8.0RC2 on OSX and I
> have
> > a problem with 'make check'.
>
> > Here is my configure..
>
> > ./configure --disable-shared ...
>
> --d
nd did the make check. all 96 tests passed.
I don't know if you need to make a note that OS X
users can not work in an admin account or if just the
normal warnings about not working as ROOT are enough.
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PRO
The one thing I didn't think about is that standard
users cannot sudo. So now I need to figure out how to
create a 'standard' user with privs high enough to
sudo to install.
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes
wanted to test the installation so I did a
createlang (for plpgsql) and a
createdb extremedb
psql extremedb
wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > Here is (was) the problem. I was working in an
> > administrator account. Not Root, but an admin
> accoun
erent machines. Subversion really helps me with
that one.
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > the full path was:
> > /Users/asacksadmin/Documents/postgresql-8.0.0rc2
>
> Really? What I see at
>
http://a
y bad... mea culpa yada yada. so
sorry
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > that's correct, that was the computer at home at
> that
> > does have the space in the path..
>
> > however my machine in
I am trying to use the libpg interface on OS X with
rc3. There must have been a change that I am not
understanding.
When I compile my app (xcode) I get the following
error.
warning prebinding disabled because dependent library:
/usr/local/pgsql/lib/libpq.3.dylib in not prebound
Can someone help
There is only one row in the table?
> select to_char(day, 'DD/MM/') from test_table;
what happens with:
select * from test_table; or
select day from test_table;
What does your insert statement look like? What is the
column type?
Ted
--- Tomás Zandoná <[EMAIL PROTECTED]> wrote:
>
> The fo
I just updated to 10.3.9 and of course the /etc/rc was
dinged. I opened the /etc/rc and found a change..
# System tuning
sysctl -w kern.maxvnodes=$(echo $(sysctl -n
hw.physmem) '33554432 / 512 * 1024 +p'|dc)
if [ -f /etc/sysctl-macosxserver.conf ]; then
awk '{ if (!index($1, "#") && index(
; set it based on
> /etc/syscttl.conf, but that (large) setting would
> then be over-written
> by the subsiquent sysctl -w.
>
> On Fri, Apr 29, 2005 at 09:39:55AM -0700, Theodore
> Petrosky wrote:
> > I just updated to 10.3.9 and of course the /etc/rc
> was
> > d
unately, since I only have one mac
> and it's my primary
> computer and testing this requires a number of
> reboots I'm not keen on
> spending more time experimenting with it, but if
> someone has ideas on a
> more elegant fix I'm all ears.
>
> I provided a
I don't know if this is a bug or my not understanding
something.
I installed 8.1beta4 on a machine (mac os x 10.4.2). I
have my pg_dump file from my running 8.0.3 server in
the office (os x 10.3.9).
I created a cluster with: initdb --encoding-UNICODE
/path/to/dir
then createdb databasename
psql
79 matches
Mail list logo
