I am working with a database that was not created by our team. There are
some indexes set up on a table and I need to understand what type they are
and how they are functioning.
How can I look at this in Postgres?
I have a situation where we trying to update data and are receiving an error
based o
Hi,
while restoring backup i have received these messages
WARNING: column "id" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
I have tried to grep schema-only dump file, but i didn't find word unknown.
When i have extracted all mentioned ID fields i didn't find any field wh
Didik Prasetyo wrote on 07.05.2011 09:28:
I want to ask how to make GRANT, where users can only perform SELECT
on all the TABLE, in the database, which I have done the following
You might consider upgrading, because since 9.x you can do:
GRANT SELECT ON ALL TABLES IN SCHEMA public;
Thomas
-
e system
tables, but I'll leave that version of the answer to the smarter folk.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter
> Sent: Monday, January 07, 2002 4:25 PM
> To: Postgres Admin List
> Subject:
Jodi Kanter writes:
> I am working with a database that was not created by our team. There are
> some indexes set up on a table and I need to understand what type they are
> and how they are functioning.
> How can I look at this in Postgres?
\d tablename or \d indexname in psql.
--
Peter Eisen
Hi,
I'm getting the following error in my log file. Normally it's every 10
minutes, but occasionally the frequency changes to 5min, 3,1,30sec, 10sec, 5sec
and then every second.Weeks ago it took the db down with a disk full
situation, but usually it clears after a few minutes of continuous
=?UTF-8?Q?Viktor_Bojovi=C4=87?= writes:
> while restoring backup i have received these messages
> WARNING: column "id" has type "unknown"
> DETAIL: Proceeding with relation creation anyway.
It's most likely a view with an output column that's an undecorated
string literal.
> I have tried to gr
On Wed, May 4, 2011 at 3:58 PM, Tom Lane wrote:
> =?UTF-8?Q?Viktor_Bojovi=C4=87?= writes:
> > while restoring backup i have received these messages
> > WARNING: column "id" has type "unknown"
> > DETAIL: Proceeding with relation creation anyway.
>
> It's most likely a view with an output colum
Hi,
Postgres server crashed on windows vista.
From the log:
2010-04-07 07:00:35.694 LOG: could not receive data from client: Unknown
winsock error 10061
2010-04-07 07:00:35.694 LOG: could not receive data from client: Unknown
winsock error 10061
2010-04-07 07:00:35.694 LOG: unexpected EOF o
On Wed, Jan 5, 2011 at 7:16 AM, Little, Douglas
wrote:
>
> Env:Greenplum 3.3.6(based on PG 8.2.13), Solaris 10u5, Sun X4540 (x86)
>
> We are probing the machine with sitescope for cpu/mem/disk stats, but I
> don’t believe it’s connecting to the db.
>
>
>
> 2011-01-01 13:01:56.848368 CST,"root
, January 05, 2011 10:32 AM
To: Little, Douglas
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unknown log messages
On Wed, Jan 5, 2011 at 7:16 AM, Little, Douglas
mailto:douglas.lit...@orbitz.com>> wrote:
Env:Greenplum 3.3.6(based on PG 8.2.13), Solaris 10u5, Sun X4540 (x86)
Could it be an automatic process, kicked off by cron or some such, running as
root, and not specifying the db or user, therefore defaulting to root & root?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsq
On Jan 5, 2011, at 9:34 AM, Little, Douglas wrote:
> No dbuser named Root.
That's my point, you don't have a db user named root, but you do (maybe) have a
process running as root trying to connect to the db.
> So it sounds like the log messages are standard for a login attempt with
> unknown u
On Wed, Jan 5, 2011 at 9:15 AM, Scott Ribe wrote:
> On Jan 5, 2011, at 9:34 AM, Little, Douglas wrote:
>
>> No dbuser named Root.
>
> That's my point, you don't have a db user named root, but you do (maybe) have
> a process running as root trying to connect to the db.
>
>> So it sounds like the l
i need some help with this errors:
"Unknown user name or password.
Unsupported frontend protocol.
Alias: PostgreSQL"
I'm using delphi 4. But the error is in ODBC
Thanks in advance
Thiago Nelson
[EMAIL PROTECTED]
"Sofer, Yuval" wrote:
> Postgres server crashed on windows vista.
What causes you to say that the server crashed?
> 2010-04-07 07:00:35.694 LOG: could not receive data from client:
> Unknown winsock error 10061
> 2010-04-07 07:00:35.694 LOG: could not receive data from client:
> Unknown wi
Go into the odbc configuration and look under advanced options. There
is a way to select which version of PostgresSQL you're talking to.
At 12:21 PM 5/31/99 -0300, [EMAIL PROTECTED] wrote:
>i need some help with this errors:
>
>"Unknown user name or password.
>Unsupported frontend protocol.
I've got a directory with ~14000 files in it. I would like
to enter the name of the file and its contents into a
database table on another host. So I use a shell command
to iterate through the files. Most of them work but others fail
as you see below. Multiple runs in the same directory have s
18 matches
Mail list logo