HI Ashish,
Try to download the source for Linux installation from the PgAdmin site.
untar and try to complile using ./configure make and make install steps.
Just test what happens. I too do not see any options give somewhere. you can
also go through Readme file give with the source binary. I am
"Phillip Smith" <[EMAIL PROTECTED]> writes:
>>> 2007-07-25 11:52:05 EST @ []DETAIL: The data directory was initialized
>>> by
>>> PostgreSQL version 8.3, which is not compatible with this version 8.2.4.
> Is it worth me trying to fix this stuff up on my behalf? Or should I just go
> back to last
"Phillip Smith" <[EMAIL PROTECTED]> writes:
>> Now PostgreSQL complains at me with the following error:
>> 2007-07-25 11:52:05 EST @ []DETAIL: The data directory was initialized
by
>> PostgreSQL version 8.3, which is not compatible with this version 8.2.4.
>> As far as I'm aware, 8.3 doesn't exis
"Phillip Smith" <[EMAIL PROTECTED]> writes:
> Now PostgreSQL complains at me with the following error:
> 2007-07-25 11:52:05 EST @ []DETAIL: The data directory was initialized by
> PostgreSQL version 8.3, which is not compatible with this version 8.2.4.
> As far as I'm aware, 8.3 doesn't exist!
Most database systems can figure out the size (in bytes) of a column
rather quickly from offsets within a record. I doubt that postgres is
any different. The only difference I can think of is that it might be
slower to filter out trailing spaces of a char column before comparing,
though the act
> I'm assuming the problem is because the PG_VERSION file in the data
> directory says 8.3, so I'm making a copy of the directory, changing that
to
> 8.2 and see if it will start with that.
Well that didn't work!
[EMAIL PROTECTED] pgData-8.2]$ pg_ctl -o '-i' start
server starting
2007-07-25 12:13:
Hi All,
Just tried to recompile (what I thought!) was the same version of PG that I
already had running, to add in the AdminPack to stop pgAdmin complaining
about it being missing.
After recompiling from source, with the Admin Pack (did it on a devel box
first to make sure I was doing the right t
2007/7/24, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hello everybody.
I'm using PostgreSQL on Windows XP.
I had to format de harddisc, and I'm lost databases and tablespaces
configuration (1 database and 1 tablespace), I have a copy of directory
where was the tablespaces ( but I haven't a backup m
run this in the command line
locate postmaster.pid
or
find / -name "postmaster.pid" -print
that should locate any postmaster files and then remove whatever looks
like the postmaster.pif file
---(end of broadcast)---
TIP 2: Don't 'kill -9' the po
Andrew Sullivan wrote:
On Mon, Jul 23, 2007 at 11:33:54AM -0700, Jessica Richard wrote:
What is the difference between varchar and text for a string column?
What is the benefit of using each one?
Is text better than varchar performance wise?
From the manual:
Tip: There are no perform
Hello everybody.
Im using PostgreSQL on Windows XP.
I had to format de harddisc, and Im lost databases and tablespaces
configuration (1 database and 1 tablespace), I have a copy of directory
where was the tablespaces ( but I havent a backup made by pgAdmin ).
What do I for set up my database
The only difference is that varchar can have a length limit, text is always
unlimited length. There's no significant performance difference between
either. For most intents and purposes, they're equal.
Forgive me for diversion, but out of curiosity, would it make some
difference whether string
<[EMAIL PROTECTED]> writes:
> During installation of postgresql 8.2.4 on Mandriva 2007.1 I get the follow=
> ing log after typing 'gmake install'
> cp: setting attributes for `/usr/local/pgsql/man/man1/_inst.4301_': Operace=
> nen=C3=AD podporov=C3=A1na {operation/command is not supported}
> gmak
Christoph Heibl wrote:
Thanks a lot for your help! By deleting the pgsql directory I get some
steps further. Now I get stuck by a error message saying
"postmaster.pid" already exists, when I try to start postmaster. I am
not really sure what this means because I think I initiated the database
During installation of postgresql 8.2.4 on Mandriva 2007.1 I get the following
log after typing 'gmake install'
gmake -C doc install
gmake[1]: Entering directory `/home/sg/tmp/postgresql-8.2.4/doc'
gzip -d -c ./postgres.tar.gz | ( cd /usr/local/pgsql/doc/html && /bin/tar xf - )
for file in man1/*
Thanks a lot for your help! By deleting the pgsql directory I get
some steps further. Now I get stuck by a error message saying
"postmaster.pid" already exists, when I try to start postmaster. I am
not really sure what this means because I think I initiated the
database only once, but I gue
16 matches
Mail list logo
