Hmm, not good - I've forwarded this to the techdocs author.
Regards, Dave
-Original Message-
From: Jason McManus [EMAIL PROTECTED]
To: Dave Page dpage@vale-housing.co.uk
Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org
Sent: 02/07/06 05:00
Subject: Re: [GENERAL] Notes on
Uwe C. Schroeder wrote:
You can technically just copy paste the postgresql data directory IF YOU
SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
same version of postgresql. Also: this is not a good way to do it and I'd
encourage you not to use this as general
On Sat, Jul 01, 2006 at 06:23:07PM -0400, Tom Lane wrote:
Tomi NA [EMAIL PROTECTED] writes:
Basically, it comes down to three possibilities, doesn't it:
1.) use an existing library
2.) write a pgsql specific implementation
3.) forget about it and tend to other issues
Personally, I
Tomi NA wrote:
On 6/30/06, Martijn van Oosterhout kleptog@svana.org wrote:
On Fri, Jun 30, 2006 at 11:56:19AM +0200, Dragan Matic wrote:
I have two postgres servers, one on linux (fedora core 5), one on
windows, both are version 8.1.4.
Not beeing able to depend on the engine to
On Sun, Jul 02, 2006 at 12:13:02PM +0200, Martijn van Oosterhout wrote:
However, the most important point is that people have said they'll take
the speed hit if they could get consistant collation.
I can second that.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD
Hi,
I started using PostgreSQL (8.0) about a year ago on Windows. Following
the installation instructions, I created a 'postgres' user (BTW, this
was based on the Short Version instructions for UNIX, i.e., adduser
postgres --I'm not sure it this is made explicit elsewhere, even for UNIX).
On 7/2/06, Joe [EMAIL PROTECTED] wrote:
Hi,
I started using PostgreSQL (8.0) about a year ago on Windows. Following
the installation instructions, I created a 'postgres' user (BTW, this
was based on the Short Version instructions for UNIX, i.e., adduser
postgres --I'm not sure it this is made
Joe [EMAIL PROTECTED] writes:
I'm now migrating to FreeBSD and was surprised to find that the port
used 'pgsql' as the user. The maintainer said that was done to ensure
backward compatibility because that *was* the original name.
It's always been postgres, at least as far as the standard
-Original Message-
From: David Fetter [mailto:[EMAIL PROTECTED]
Sent: 30 June 2006 18:30
To: Dave Page
Cc: Scott Marlowe; Jason McManus; pgsql general
Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x
to PostgreSQL
Last I checked, pgAdmin 1.4 doesn't help setting
Tom Lane wrote:
FreeBSD is out in left field here. However, I don't see why you need to
alter the build to change this. Just create a new user postgres and run
the initdb step as that user. initdb uses the OS user name it's run as
to determine the initial superuser name.
That's exactly what
Joe [EMAIL PROTECTED] writes:
It was when I tried starting PostgreSQL from boot, which requires adding
postgresql_enable in /etc/rc.conf, that it didn't work. I tracked
that down to /usr/local/etc/rc.d/010.pgsql.sh which uses a
postgresql_user variable defined as pgsql by the port. And
On Jul 2, 2006, at 6:13 AM, Martijn van Oosterhout wrote:
But I don't think anyone is actually considering importing ICU into the
postgres source tree, are they?
Why not?
Size - I'm not sure this is relevent since I don't think we want to
incorporate it into postgres itself, just let people
What should the default directory for the postgres user be? I'm using
OSX 10.4. Right now, the default directory is set to /dev/null.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
Tom Lane wrote:
Plan B is to leave the pgsql user alone and add another superuser named
postgres. You can have more than one superuser ...
Yes, that's what my hosting provider (hub.org, which also hosts
postgresql.org) seems to have done. This also avoids another minor
problem: initdb on
The shell is probably /bin/false right? That indicates that the
postgres user won't log in to an active session. If that's an issue,
then you should change that to whatever you like (probably
/usr/local/pgsql/).
On Jul 2, 2006, at 12:29 PM, Victor Escobar wrote:
What should the default
On Sunday 02 July 2006 01:42, Tino Wildenhain wrote:
Uwe C. Schroeder wrote:
You can technically just copy paste the postgresql data directory IF
YOU SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for
the same version of postgresql. Also: this is not a good way to do it
Hello List:
I hope my question does not start war of the posts. This
question is genuine. Please answer objectively:
I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS,
DNS, Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master Server will
have all the software
On 2 jul 2006, at 18.29, Victor Escobar wrote:
What should the default directory for the postgres user be? I'm
using OSX 10.4. Right now, the default directory is set to /dev/null.
I've set the home directory to /var/empty and the shell to /usr/bin/
false, like most of the other daemon
Hello,
I'm getting the following error when I do this step:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data logfile 21
Exit 1: Permission denied: logfile 21
I did a chown on /usr/local/pgsql/data and am running this as postgres.
---(end of
Check where you are executing this.the user postgres does not have
permission to write logfile in your current directory
Victor Escobar wrote:
Hello,
I'm getting the following error when I do this step:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data logfile 21
Exit 1:
On 7/2/06, Agent M [EMAIL PROTECTED] wrote:
Certain Japanese characters cannot make a reliable round-trip through
Unicode. ICU uses UTF-16 as its store, so the Japanese folks won't be
happy with an ICU-only solution. However, it would still be of great
Could you explain what you mean and
Hello,
these 2 statements work fine for me on the psql-prompt:
punbb= select id, username, md5('deadbeef' || password) from users
where id = 7;
id | username | md5
+--+--
7 | Alex | b962415469222eeb31e739c3afbc8a4a
(1 row)
punbb=
On Sun, Jul 02, 2006 at 12:25:43PM -0400, Agent M wrote:
On Jul 2, 2006, at 6:13 AM, Martijn van Oosterhout wrote:
But I don't think anyone is actually considering importing ICU into the
postgres source tree, are they?
Why not?
Because it's a project of similar size to postgres and probably
On Sun, Jul 02, 2006 at 11:17:12PM +0200, Alexander Farber wrote:
snip
However when I try to execute the latter query by my C-program,
then it fails, saying that my bind command supplies 2 arguments
(yes, that's true), but the prepared statement requires 1 argument
(why 1? I don't
Victor Escobar wrote:
The directory is set to /dev/null. I also forgot to add that I'm using
OS X 10.4. Since obviously /dev/null means the bit-bucket, what should I
set the home directory to?
Always CC the list, you'll get much faster/better responses.
Set the home dir to the base of your
I hope my question does not start war of the posts. This question is
genuine. Please answer objectively:
I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS,
Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master Server will
have all the software I we need for our
you mean there are 3 tables
the list of items purchased - this is what i am asking for
the list of items purchased
What is difference between
T_SALES_CC_DETAIL and T_SALES_DETAIL
thanks a lot ron
-
hi all,
is there a command like uf_purge which purges the last x days of data.
i noticed this command somewhere but i cant find a reference to it any
documentation. is it a deprecated command and we just use delete now.
whats its functionality?
any ideas.
---(end of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Correct, 3 tables. T_SALES_DETAIL records are line items, the
stuff the customer bought. There is only a T_SALES_CC_DETAIL record
if the transaction happens to use a credit card.
a wrote:
you mean there are 3 tables
the list of items purchased -
On Sun, Jul 02, 2006 at 06:40:30PM -0700, [EMAIL PROTECTED] wrote:
is there a command like uf_purge which purges the last x days of data.
i noticed this command somewhere but i cant find a reference to it any
documentation. is it a deprecated command and we just use delete now.
whats its
Kirti S. Bajwa wrote:
Hello List:
I hope my question does not start war of the posts. This question is
genuine. Please answer objectively:
I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS,
DNS, Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master
Server will
Dragan Matic [EMAIL PROTECTED] writes:
I was about to say the same thing. I think that the whole point in
having a portable database system is that the data inside the database
should behave the _same way_ no matter what operating system database is
running on - client shouldn't be aware of
32 matches
Mail list logo
