Hi all. I'm looking at distributing PostgreSQL with a desktop
application and have a couple of what might be simple questions.
I've been using PG for years and years but bringing it to the Win32
desktop presents some deployment challenges. Since this software will
be downloaded I am looking for th
Hi. I am new to postgres. I would like some advise on how to get a minimum
postgres installation. I want to use postgres embedded in application on
windows.
I have done the following.
C:\Program Files\PostgreSQL>msiexec /i postgresql-8.2-int.msi /qr
INTERNALLAUNCH=1 ADDLOCAL=server,psql SERV
Richard Broersma Jr wrote:
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
Hello,
For those who were too square to be there,
For us squares, are there any pictures avaliable of this event?
Yes :)... they are coming. I hope to have them all this weekend.
Joshua D. Drake
Regards,
Richar
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> For those who were too square to be there,
For us squares, are there any pictures avaliable of this event?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 9: In versions b
Here are just a few observations.
What you have described is a classic taxonomy problem. The simplest approach
is to create a table to contain the basic attributes of the obtjects in the
database. Using your example, such attributes may be anatomical (two eyes, two
ears, four limbs, one
Lincoln Yeoh wrote:
Hi, importantly do searches and other processing by those relationships.
So, what would be the best way to store them so that a search for the
relationship like "grass is to cow", will also turn up cow is to
tiger, and goat is to tiger, and fish is to penguin (and penguin i
Hi,
Sorry, this really isn't postgresql specific, but I figure there are
lots of smarter people around here.
Say I have lots of different objects (thousands or even millions?).
Example: cow, grass, tiger, goat, fish, penguin.
BUT I'm not so interested in defining things by linking them to
Does Postgresql have a function like ascii() that will
return the unicode codepoint value for a utf8 character?
(And symmetrically same for question chr() of course).
I didn't find anything in the docs so I think the answer
is no which leads me to ask... Why not? (Hard to believe
lack of need
Success!
Here's what happened:
1. I should -not- use sudo to "make install", since my user already had the
required permissions. Using sudo messed up and caused those permission
errors.
2. As I mentioned before, I did install pg through the package system
before. The problem is: when I removed th
Ok, I found the problem: Permissions.
Although I -do- have write/read/exec permission /usr/local/pgsql , some
files couldn't be copied after the install, probably rendering PG a bit
unstable =)
I tried installing PG in a folder in my home directory, and it worked like a
charm.
Here's the output
On 7/27/07, Paolo Victor <[EMAIL PROTECTED]> wrote:
>
> Ok, I found the problem: Permissions.
>
> Although I -do- have write/read/exec permission /usr/local/pgsql , some
> files couldn't be copied after the install, probably rendering PG a bit
> unstable =)
Erm, I guess I mean "the config procces
Hello,
For those who were too square to be there, here is my wrap up on the
PostgreSQL presence at OSCON 2007. Don't miss LinuxWorld 2007, it stands
to be even better!
http://www.commandprompt.com/blogs/joshua_drake/2007/07/oscon_2007_postgresql_army_of_smurfs/
I would also note that Postgre
First: Thanks for all the advice!
David:
I tried installing the system's packages, but as I plan using the python
procedures feature, I've got to compile it with the "--with-python" option.
I'm not sure if the default package already includes the feature, but since
the createlang command failed a
At 05:13 AM 7/25/2007, James B. Byrne wrote:
I can connect from the httpd host to the postgresql host using psql and it
shows that an ssl connection with a 256 bit key is in use. However, I
would like to verify that the web app is also using ssl and I cannot seem
to find any logging setting or
On 7/27/07, David Fetter <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 27, 2007 at 11:28:58AM -0300, Paolo Victor wrote:
> > Hello,
> >
> > For a short description, I'll just show the sequence of commands I'm trying
> > to execute:
> >
> > [EMAIL PROTECTED]> initdb -D /usr/local/pgsql/data/
>
> This loo
At 09:26 PM 7/26/2007, James B. Byrne wrote:
Is there a way to use a key larger than 256 bits and is there any reason
why this would not be useful in practice? Our standard key sizes here
seem to by either 1024 or 2048.
Hi,
There's a difference between a symmetric key, and a public key. 256
On Fri, Jul 27, 2007 at 11:28:58AM -0300, Paolo Victor wrote:
> Hello,
>
> For a short description, I'll just show the sequence of commands I'm trying
> to execute:
>
> [EMAIL PROTECTED]> initdb -D /usr/local/pgsql/data/
This looks like a mistake. Unless you plan to develop the PostgreSQL
code
Hello,
For a short description, I'll just show the sequence of commands I'm trying
to execute:
[EMAIL PROTECTED]> initdb -D /usr/local/pgsql/data/
[EMAIL PROTECTED]> postgres -D /usr/local/pgsql/data -i -p 5435
[EMAIL PROTECTED]> createdb foo -p 5435
createdb: could not connect to database foo: F
On 7/25/07, Geoffrey <[EMAIL PROTECTED]> wrote:
> We plan to upgrade from our current 7.4.17 Postgresql to 8.2.? in the
> near future. We also plan to implement a replication solution, most
> likely Slony.
>
> We know that the upgrade to 8.2.? will require some code changes.
>
> Question is, is th
On 7/26/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm developing a BI and as database it's using postgresql 8.2, how data
> are very detailed, I'm creating a view to consolidate the most important
> data, but the performance of view is very poor, 1 minute to perform more
> or less
On Fri, July 27, 2007 04:20, Albe Laurenz wrote:
>
> This is more a philosophical question.
>
> If you only allow hostssl connections in pg_hba.conf AND forbid
> all host connections (with one last 'reject' line), PostgreSQL
> will reject all connections that are not via SSL.
>
> If your "securit
Luca Ferrari wrote:
> Thanks all for your comments. Just another little hint here (sorry for
> trivial
> questions):
>
> if (TransactionIdIsCurrentTransactionId(HeapTupleHeaderGetXmax(tuple)))
> {
> if (tuple->t_infomask & HEAP_IS_LOCKED)
> return
On 26 Jul, 18:51, NetComrade <[EMAIL PROTECTED]> wrote:
> I apologize for cross-posting, but I need some help w/o too many
> advices RTFM :). After Oracle and MySQL, this becomes the third
[snip]
> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
> remove NSPAM to email
Contact me offl
James B. Byrne wrote:
> On Tue, July 24, 2007 18:29, Joshua D. Drake wrote:
>> just enforce hostssl in your pg_hba.conf and nothing else.
>> If you can connect, you are good :)
>
> Thanks, I will probably end up doing this.
>
> What I am really looking for is an audit trail for all DBM host
> con
Kaloyan Iliev wrote:
> After we migrate one function that previously doesn't make
> any problem now starts to throw error.
>
> I know this is more Perl problem but if someone could help because I
> didn't find anyting in the net.
>
> [EMAIL PROTECTED] perl
> use CLIB::LDBI;
> my $dbh = CLIB::LDB
Thanks all for your comments. Just another little hint here (sorry for trivial
questions):
if (TransactionIdIsCurrentTransactionId(HeapTupleHeaderGetXmax(tuple)))
{
if (tuple->t_infomask & HEAP_IS_LOCKED)
return true;
if (Hea
26 matches
Mail list logo
