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,
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'
>
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:
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:
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
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
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
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
; 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
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(
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 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
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
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
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
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
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
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
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
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:
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
-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 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
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
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
--- 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
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-
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
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
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
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
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
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
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
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
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!?
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
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
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
--
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 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
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
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
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
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
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
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
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
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
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
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 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)-
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
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
> &
', '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
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)
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
> >
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
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
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:
>
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)-
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.
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 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
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
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.
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
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
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
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
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
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'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
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
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
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
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
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 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'
79 matches
Mail list logo
