Van den bosch [EMAIL PROTECTED] wrote:
Unable to install postgreSQL 8 on a DNS-server, because during the
installation postgreSQL searches after \\servername\user, but the
servername differs
from the DNS name.
Is there a workaround for this problem?
Reconcile the NETBIOS and DNS
David Bear [EMAIL PROTECTED] wrote:
I'm attempting to run pgsql through a tunnel.
[snip]
Through an ssh tunnel, using port-forwarding, I'm guessing?
Am I missing something obvious?
Can you psql -p 5432 on the machine on which the server is running?
Here's what I just did successfully:
[EMAIL PROTECTED] (Mike Castle) wrote:
In article [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
If you have strace or ktrace or similar on the Solaris machine, tracing
psql's kernel calls might be revealing. What you want to watch for is
whether psql is exiting with the connection
Bruno Wolff III [EMAIL PROTECTED] wrote:
On Tue, Jul 13, 2004 at 09:54:29 +0200,
Gaetano Mendola [EMAIL PROTECTED] wrote:
Hi all,
why don't you create comp.database.postgresql.slony NG ?
It isn't that simple. For big 8 newsgroups you have to make a proposal
and people vote on it.
Gaetano Mendola [EMAIL PROTECTED] wrote:
[snip]
I was believing that the NGs news.XX.postgresql.org were managed by
postgresql developer group and the vote could be easily done trough a
poll in the postgresql web site.
For postgresql.org's own news servers, maybe. I really don't know.
But
[EMAIL PROTECTED] wrote:
Hello
i have:
create table student(
id SERIAL NOT NULL,
name VARCHAR(35) NOT NULL,
primary key (id)
);
and when i try to insert like this:
insert into student (name) values('me');
i receive error:
ERROR: duplicate key
Jeff Stout [EMAIL PROTECTED] wrote:
I am using the /contrib/start-scripts/linux file to set
up postgres to automatically restart upon reboot.
I set it up /etc/init.d/postgres which calls pg_ctl
pg_ctl invokes postmaster
where do I set the -i option to allow tcp connection?
[snip]
Set
=?iso-8859-1?q?Eduardo=20S.=20Fontanetti?= [EMAIL PROTECTED] wrote:
Hello,
I am trying to save a directory name on the Postgres,
but it is cutting some characters, and the result is
being diferent, and then, my app don't work properly.
Example:
I am trying to save S:\directory\app to
Sandro Ribeiro - Claro RS - [EMAIL PROTECTED] wrote:
Hello!
My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
connection from my PC to the server, using pgAdminIII, I get the message
above. This is my pg_hba.conf file:
local all all
Renney Thomas [EMAIL PROTECTED] wrote:
While compiling 7.4.3 on Solaris 8 (sparc) I got:
[snip]
Any patch files for this?
Yes. Bruce Momjian [EMAIL PROTECTED] posted a patch for
this to the [GENERAL] mailing list earlier today. I've saved a
copy, for your convenience, to:
Jeff Stout [EMAIL PROTECTED] wrote:
I am fairly new to postgres, I need to know how to switch
databases once I'm in a psql session. I can't seem to find the
command for \h , maybe I just blind |-;
\? is your friend...
$ psql
Password:
Welcome to psql 7.4.2, the PostgreSQL interactive
Paul Gimpelj [EMAIL PROTECTED] wrote:
Hi,
I searched the postgresql.org site but I don't understand how to get a
postmaster running on windows 98/2000.
Can someone please give some pointers here.
[snip]
Did you find
http://www.postgresql.org
Docs
PostgreSQL 7.4 - Static
David Parker [EMAIL PROTECTED] wrote:
I'm new to postgresql, first of all, and I'm not sure if this is the
correct list
I have built 7.4.2 on Solaris 8/SPARC. I *think* make install
generated all the expected
artifacts.
When I run initdb, I get the following output:
% initdb
David Parker [EMAIL PROTECTED] wrote:
[snip]
I am not running this under a separate username, so the LD_LIBRARY_PATH
set in my own .cshrc should apply, I would think. Does
/etc/init.d/postgresql still need to be modified, even if there is no
special postgresql user?
[snip]
I ran into a problem compiling 7.4.2 on Sun Solaris. The details are as
follows. Thanks
SunOS 5.8 Generic_108528-29 sun4u sparc SUNW,Ultra-1
[snip]
gcc -O3 -pthreads -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declaration
s -fPIC -I. -I../../../src/include
[EMAIL PROTECTED] wrote:
Jim said:
Try changing the 10.29.15.0255.255.255.0 to 10.29.15.0/24, if
you
have a 7.4-series pgsql server, and see if that doesn't work.
IT WORKED! Thanks so much Jim! I'm happily connected from home today...
:)
It was a long shot, but it worked. Very
(Note: Please do not copy me individually on posts to the mailing
list. I do read the list and don't need two copies. Thanks.)
(Note2: I did Cc: this to LSanchez as she's yet to respond to any of
my prior comments, so I begin to suspect she's not getting/reading
the mailing list traffic?)
Note: Please do NOT Cc: me on replies to the mailing list. I read the
mailing list. One copy of your comments is sufficient. Thank you.
Thanks Mike!
Do you know if pgSQL will be supporting higher level of encryption in
the near future? Most of us here at Ameritrade work from home via
[EMAIL PROTECTED] wrote:
Thanks Mike!
I already specified the IP address that was specified by my VPN
connection. I read through the docs and found nothing about anything
special with VPN connections.
Which address? The address at your end of the connection may not be
the same as the
Hello,
I'm trying to install PostgreSQL 7.4.2 on a brand new SunFire 120 with
2GB of RAM but when I run initdb -D /usr/local/pgsql/data I get the
following error:
[snip]
creating template1 database in /usr/local/pgsql/data/base/1... FATAL: could
not create shared memory segment:
There we go. For reference, what page did you get that info and what did
you search for to get it?
Like I said: I derived it all from Google'ing on various search
terms, IIRC. Probably things like postgresql+Solaris+shmmax and
the like. I didn't save any URL references.
Jim
=?iso-8859-15?Q?J=F8rgen_Lie_Pettersen?= [EMAIL PROTECTED] wrote:
Dear Sir or Madam!
I am a student at a university in Norway, and I'm working on a project
where I shall be a seller for PostgreSQL.
I was just wondering, why the name PostgreSQL? Is it a shortening for
something?
Thomas Burns [EMAIL PROTECTED] wrote:
Hi,
I'm having a really stupid problem -- it seems to be impossible to
download postgre.
Postgres, PostgreSQL, psql, pgsql, but not postgre, please :).
All of the US mirrors timeout. Is this normal?
There are no apparent
/init.d/postgresql and created a .profile in its home directory
with that in it.
Solved all those problems :).
You can also solve such problems by using the -R switch during build
(man ld) and with Solaris 8/9's new crle utility.
--
Jim Seymour| Spammers sue anti-spammers:
[EMAIL
I am a novice in this area.
How would I set up a new user on PostgreSQL so that the new user is limited
to reading a particular view, and can do nothing else.
Help greatly appreciated.
You will find these handy, no doubt...
http://www.postgresql.org/docs/7.4/static/tutorial.html
by using the -R switch during build
(man ld) and with Solaris 8/9's new crle utility.
--
Jim Seymour | PGP Public Key available at:
[EMAIL PROTECTED] | http://www.uk.pgp.net/pgpnet/pks-commands.html
http://jimsun.LinxNet.com|
---(end of broadcast
kandiah ratnavale [EMAIL PROTECTED] wrote:
I downloaded postgresql (client, server and libs) but cannot complete
installation for want of the libraries listed below
libcrypto.so.2 is needed by postgresql-7.2.3-2PGDG
libssl.so.2 is needed by postgresql-7.2.3-2PGDG
. Providing the server version hasn't changed, all
should be well.
--
Jim Seymour| Spammers sue anti-spammers:
[EMAIL PROTECTED] | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund
Ben Kim [EMAIL PROTECTED] wrote:
Dear admins,
I have a table whose primary key is a record_id with serial type.
I would like to know, when I insert a new row, what was the value of the
record_id that I just inserted. Since this is a multi user application, I
cannot simply select max
Marc G. Fournier [EMAIL PROTECTED] wrote:
On Mon, 5 Apr 2004, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
D'oh ... just tested my assumption, it was wrong ... *sigh* okay, back
to the drawing board on the code ...
Can't you just change
foreach $company_id (
[EMAIL PROTECTED] (Bud Curtis) wrote:
[snip]
When I attempt to start the server, ie.:
-bash-2.05b$ postmaster -D /usr/local/pgsql/data
FATAL: /usr/local/pgsql/data is not a valid data directory
DETAIL: File /usr/local/pgsql/data/PG_VERSION is missing.
-bash-2.05b$
[snip]
Eduardo Sachwek Fontanetti [EMAIL PROTECTED] wrote:
How can I do it? I really can't, something is not working and when I
try to connect to the postgreSQL server Linux machine from the PgAdmin
III, it says me that cant connect, and say me to check the port
(5432).
What may be wrong?
32 matches
Mail list logo