On Mon, Sep 25, 2000 at 03:45:59PM -0400, Adam Lang wrote:
> To be a user to interact with postgres, do you have to be a user on the
> system it is installed at?
No (although it's possible to set it up that way if you choose).
Database users are independent of system users.
> i.e. Jane works fro
[EMAIL PROTECTED] (Randall Smith) writes:
> This is the error I get:
> ODBC Error Code = S1000 (General error)
> Could not connect to the server; Could not connect to remote socket.
> Any thoughts?
DNS problems? Firewall packet filtering? It sounds like you're never
getting as far as talking t
"Adam Lang" <[EMAIL PROTECTED]> writes:
> i.e. Jane works from home and uses a program that access the database
> remotely. Does Jane need to be a user on the database server as well as a
> user in postgresql?
No. Postgres users don't have to be related at all to Unix users on the
server's syst
The machines are on the same subnet, nearly side by side. I thought maybe I
could telnet into port 5432 but still no luck... it's as if postmaster isn't
taking tcp connections of any kind. Both machines have proper
forward/reverse dns and no packet filtering exists between them. How can I
verify p
Did you start postmaster with the -i option?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Randall Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 4:51 PM
Subject: Re: [GENERAL] PostgreSQL on Cobalt Raq and Co
Hi all,
What psql or sql commands can be used to view the
structure of a table?
I've been reading through the documentation online and
can't find the answer.
Thanks,
Andrew Gould
__
Do You Yahoo!?
Send instant messages & get email alerts with Ya
Hi all,
I use Suse Linux 6.4 (kernel 2.2.14) and when I'm executing SQL
statements in batch to postgresql (like: psql db < schema.sql) I have a
fair chance that Linux reboots. No entries about the mishap are logged
in the postgres logfile and neither in /var/log/messages. There's no
telling when
Hi Folks,
I'm trying to get DBD::Pg installed (I've tried directly and through
CPAN) - and I get the following error: please set environment
variables POSTGRES_INCLUDE and POSTGRES_LIB!
I looked then at the source tree - found the README, then looked at
the makefile. The variables POSTGRES_IN
If there isn't any kernel panic (or other error message) displayed then I'd
bet it's a memory problem (it's almost certainly a hardware problem),
PostgreSQL is just triggering it (probably by using the damaged memory).
I've seen this happen before with other programs... Try switching out the
RAM a
Try "netstat -nap" on the PostgreSQL box and see if the postmaster is
listening to requests at all.
HTH,
Poul L. Christiansen
Randall Smith wrote:
>
> The machines are on the same subnet, nearly side by side. I thought maybe I
> could telnet into port 5432 but still no luck... it's as if postma
* Nils Zonneveld <[EMAIL PROTECTED]> [000925 14:43] wrote:
> Hi all,
>
> I use Suse Linux 6.4 (kernel 2.2.14) and when I'm executing SQL
> statements in batch to postgresql (like: psql db < schema.sql) I have a
> fair chance that Linux reboots. No entries about the mishap are logged
> in the post
On Mon, Sep 25, 2000 at 05:51:57PM -0400, Michelle Murrain wrote:
> I'm trying to get DBD::Pg installed (I've tried directly and through
> CPAN) - and I get the following error: please set environment
> variables POSTGRES_INCLUDE and POSTGRES_LIB!
>
> I looked then at the source tree - found th
At 5:51 PM -0400 9/25/00, Michelle Murrain wrote:
>Hi Folks,
>
>I'm trying to get DBD::Pg installed (I've tried directly and through
>CPAN) - and I get the following error: please set environment
>variables POSTGRES_INCLUDE and POSTGRES_LIB!
>
>I looked then at the source tree - found the README
On Mon, Sep 25, 2000 at 01:54:09PM -0700, Andrew Gould wrote:
> What psql or sql commands can be used to view the
> structure of a table?
Using psql, try:
\d table_name
For more psql commands, look at the output of '\?' from inside psql.
HTH,
Neil
--
Neil Conway <[EMAIL PROTECTED]>
Get
> I use Suse Linux 6.4 (kernel 2.2.14) and when I'm executing SQL
> statements in batch to postgresql (like: psql db < schema.sql) I have a
> fair chance that Linux reboots.
I've had spontaneous reboot problems with several Linux and FreeBSD
systems. In every single case, the problem turned out
Thanks for everyone who helped. I'm making progress. A quick port scan
revealed that postmaster was running on 5583. I guess Cobalt in
non-standard. I can now talk to postmaster but I'm getting an authenication
error like:
ODBC Error Code = S1000 (General error)
The database does not exist on the
Hi folks,
I thought (now that I've solved my DBD::Pg problem) that I'd ask a
fairly generic opinion question. I've been working with postgres and
php now for about 4 years, quite heavily in the last year. I'm sold
on postgres, and will continue to use it unless I have compelling
reasons not t
I too use PHP and PostgreSQL for %90 of my web programming projects (C
for the other %10)... I find the embedded nature of PHP to aide in
development more than anything (though I suppose you can get that from
mod_perl as well).. I don't do much Perl at all, I found the language to be
sloppy an
If you want users to access your database remotely. Goto www.phpwizard.net
or www.phpwizards.net and look for a product call "myPostgresql " (I believe)
which iprovides a web based interface for Postgresql
And ithe program is Free, no licence ietc etc.
On Tue, 26 Sep 2000, Adam Lang wrote:
> T
-Hello
- If you want the default value to be "0" the code for that is
default = '0'
Like so
CREATE TABLE Customer (Customer_ID INT Default = '0',
I believe this should work.
dannyh
[EMAIL PROTECTED]
On Mon, 25 Sep 2000, Philip Warner wrote:
> At 19:22 24/09/00 -0500, Dominic J. Eidson wrote
20 matches
Mail list logo
