"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
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 successf
[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 th
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 kno
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
[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: duplic
"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?
"=?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:\
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:
f
"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 interact
"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
"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]
/etc/i
"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:
<[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,
>
> 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 -I/
(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 vi
>
> Hello,
>
> I believe I found my problem. The Cisco VPN client I use encrypts data
> at a 168 bit level. Postgres only supports up to 128 bit correct?
That's your VPN's end-to-end/network-to-network connectivity. It has
nothing to do with PostgreSQL at all.
(Note: Please do NOT copy me on
<[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
>
> 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
-
>
> 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 segme
=?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 appa
ser, just within the last few days...
Is directory containing libreadline in LD_LIBRARY_PATH when you're su'd
to the postgreSQL user?
I added
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib; export LD_LIBRARY_PATH
to /etc/init.d/postgresql and created a .profile in its home dire
>
> 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
rofile 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 | PGP Public Key available
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
ld carefully back up, first!)
and re-start pgsql. 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
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 s
[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.0
"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
> >
> >
"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 wr
, 412 rows sampled, 412 estimated total rows
VACUUM
I can understand how a non-full vacuum might fail if I have
insufficient FSM. But "full" should get around that, should it not?
Any idea of what might be going on here?
TIA,
Jim
--
Jim Seymour | PGP P
34 matches
Mail list logo
