pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem
13+ messages / 11 participants
[nested] [flat]

* Problem
@ 2002-04-29 06:31 Ram <ram@anantinfotech.com>
  2002-07-02 19:03 ` Re: Problem Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 13+ messages in thread

From: Ram @ 2002-04-29 06:31 UTC (permalink / raw)
  To: pgsql-bugs

Sir,
I dont know whether this is a right place to ask this question,but I
hope you guys will still help me out.
I'm in a serious problem,we are using Postgres having 2-3
databases,today when i started the server I couldnot find a single
database,also it is not allowing me to create a new one.Its showing the
following error
# createdb test;
psql: FATAL 1:  Database "template1" does not exist in the system
catalog.
createdb: database creation failed

What could be the reason ?
Please help me out.
Thanx in Advance.

Ram






^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Problem
  2002-04-29 06:31 Problem Ram <ram@anantinfotech.com>
@ 2002-07-02 19:03 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 13+ messages in thread

From: Tom Lane @ 2002-07-02 19:03 UTC (permalink / raw)
  To: Ram <ram@anantinfotech.com>; +Cc: pgsql-bugs

Ram <ram@anantinfotech.com> writes:
> # createdb test;
> psql: FATAL 1:  Database "template1" does not exist in the system
> catalog.

What PG version is this?  Can you get into any of your other databases?
If so, what do you get from "SELECT * FROM pg_database"?

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Problem
@ 2002-09-11 07:37 Prasanna <prasannaphatak@vsnl.net>
  2002-09-16 15:12 ` Re: [BUGS] Problem Stephan Szabo <sszabo@megazone23.bigpanda.com>
  0 siblings, 1 reply; 13+ messages in thread

From: Prasanna @ 2002-09-11 07:37 UTC (permalink / raw)
  To: pgsql-bugs

Hello,
 
I’m a standalone user of Linux 7.3. I’m facing problem to start sql
command
Interpreter i.e. psql. See I’ve first of all created a database using
initdb dbms
Command it gets created. And it also creates directory dbms which
contains
Many files and directories. That directory is /home/Prasanna/dbms.
Now I want to start the server so I can start it by giving command 
/usr/bin/postmaster –D dbms
so it gets started. Now if I gave command like psql –D dbms
Then it gives error like
 
Fatal 1: database name ‘dbms’ is not present in the system catalog.
 
Now what should I do? This fatal error appears on the postmaster server.
I’ve tried two nights for this psql but not getting success. May be I’m
wrong.
Will you please tell me how to start the psql with my database created
by 
Initdb. It will be very helpful to me.
 
Thank You,
Regards
________________________________________________
Prasanna Prabhakar Phatak
20/21, "Prabhalaxmi", Patwardhan Baug, Erandwane Pune 4
Ph. +91 020 5466022
email. prasannaphatak@indiatimes.com, ppp_pras@yahoo.com
 

^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: [BUGS] Problem
  2002-09-11 07:37 Problem Prasanna <prasannaphatak@vsnl.net>
@ 2002-09-16 15:12 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
  0 siblings, 0 replies; 13+ messages in thread

From: Stephan Szabo @ 2002-09-16 15:12 UTC (permalink / raw)
  To: Prasanna <prasannaphatak@vsnl.net>; +Cc: pgsql-admin@postgresql.org


-bugs is the wrong place, redirected to -admin.

On Wed, 11 Sep 2002, Prasanna wrote:

> I’m a standalone user of Linux 7.3. I’m facing problem to start sql
> command
> Interpreter i.e. psql. See I’ve first of all created a database using
> initdb dbms
> Command it gets created. And it also creates directory dbms which
> contains
> Many files and directories. That directory is /home/Prasanna/dbms.
> Now I want to start the server so I can start it by giving command
> /usr/bin/postmaster –D dbms
> so it gets started. Now if I gave command like psql –D dbms
> Then it gives error like
>
> Fatal 1: database name ‘dbms’ is not present in the system catalog.
>
> Now what should I do? This fatal error appears on the postmaster server.
> I’ve tried two nights for this psql but not getting success. May be I’m
> wrong.
> Will you please tell me how to start the psql with my database created
> by
> Initdb. It will be very helpful to me.

The location of the data directory is not a database name, databases are
stored inside that location.  Try psql template1 or make a database
with createdb and connect to that (template1 is one of the template
databases for new databases so stuff you do there can pollute other
databases you create).





^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* problem
@ 2004-05-14 08:17 Tomasz Lisica <tomaszl@zeto.olsztyn.pl>
  0 siblings, 0 replies; 13+ messages in thread

From: Tomasz Lisica @ 2004-05-14 08:17 UTC (permalink / raw)
  To: pgsql-bugs

Hi,
i installed Postrgersql 7.5 Win version and postmaster
gives me the following error:

unknown option -- t

WindowsXP Prof

Regards,
tom
tomaszl@zeto.olsztyn.pl




^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* problem
@ 2005-08-01 13:26 Vincenzo Montemurro <v.montemurro@convergere.com>
  0 siblings, 0 replies; 13+ messages in thread

From: Vincenzo Montemurro @ 2005-08-01 13:26 UTC (permalink / raw)
  To: pgsql-bugs

I all , kindly I have had an problem with the db postgresql 7.2 (arranges optimal) but job on a auentiicazione table and now this table is delete.  The manager asks nfoomatiion on this happened to me.  I would not want to give the impression of a human error bcause that job single on this table, being of ninth having delete null.  Kindly you could help understand, in this problem is  happened and cokme to obviate?  Thanks


Tank Vincenzo 

^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* problem
@ 2008-04-22 22:19 Khobotko Oleg <oleg@1pr.ru>
  2008-04-25 10:06 ` Re: problem Zdenek Kotala <Zdenek.Kotala@Sun.COM>
  0 siblings, 1 reply; 13+ messages in thread

From: Khobotko Oleg @ 2008-04-22 22:19 UTC (permalink / raw)
  To: pgsql-bugs

Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one ????
thx alot for your answers.
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 

select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1;
              passwd                | ctid  | xmin |   xmax   |   cmin   
| cmax                                                             
-------------------------------------+-------+------+----------+----------+-----                                                              
-
                                    | (0,1) |    1 | 16754522 | 16754522 
|    0
md510db8c04d26d32185270721fcf32155 | (0,2) |    2 |        0 |        0 
|    0
(2 rows)
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 

select * from pg_shadow where usesysid=1;
usename  | usesysid | usecreatedb | usesuper | usecatupd |               
passwd                                                                              
| valuntil | useconfig
----------+----------+-------------+----------+-----------+---------------------                                                              
----------------+----------+-----------
postgres |        1 | t           | t        | t         
|                                                                                                   
|          |
postgres |        1 | t           | t        | t         | 
md510db8c04d231142d5                                                              
270721fcf740ed5 | infinity |
(2 rows)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 


Tom Lane пишет:
"spol@mail.ru" <spol@mail.ru> writes:
 
> I have two "postgres" user. How to delete the first one ???
>     

Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
two rows?

            regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: problem
  2008-04-22 22:19 problem Khobotko Oleg <oleg@1pr.ru>
@ 2008-04-25 10:06 ` Zdenek Kotala <Zdenek.Kotala@Sun.COM>
  0 siblings, 0 replies; 13+ messages in thread

From: Zdenek Kotala @ 2008-04-25 10:06 UTC (permalink / raw)
  To: Khobotko Oleg <oleg@1pr.ru>; +Cc: pgsql-bugs

The first record ctid=(0,1) is obsolete, you can delete it. It is probably race 
condition in VACUUM and catalog modification. Did you added or modified any user 
account (e.g. password change) in related time? Please, can you let us know 
exact version of PostgreSQL?

		Zdenek


Khobotko Oleg napsal(a):
> Hello, help me please,
> I don't know how, but i got 2 postgres users.
> How can I delete the first one ????
> thx alot for your answers.
> /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
> 
> select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1;
>              passwd                | ctid  | xmin |   xmax   |   cmin   
> | cmax                                                             
> -------------------------------------+-------+------+----------+----------+-----                                                              
> -
>                                    | (0,1) |    1 | 16754522 | 16754522 
> |    0
> md510db8c04d26d32185270721fcf32155 | (0,2) |    2 |        0 |        0 
> |    0
> (2 rows)
> ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
> 
> select * from pg_shadow where usesysid=1;
> usename  | usesysid | usecreatedb | usesuper | usecatupd |               
> passwd                                                                              
> | valuntil | useconfig
> ----------+----------+-------------+----------+-----------+---------------------                                                              
> ----------------+----------+-----------
> postgres |        1 | t           | t        | t         
> |                                                                                                   
> |          |
> postgres |        1 | t           | t        | t         | 
> md510db8c04d231142d5                                                              
> 270721fcf740ed5 | infinity |
> (2 rows)
> //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
> 
> 
> Tom Lane пишет:
> "spol@mail.ru" <spol@mail.ru> writes:
> 
>> I have two "postgres" user. How to delete the first one ???
>>     
> 
> Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
> two rows?
> 
>            regards, tom lane
> 




^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* problem
@ 2020-04-24 20:58 reda kodi <kodi_reda@hotmail.com>
  2020-04-24 21:28 ` Re: problem Bruce Momjian <bruce@momjian.us>
  2020-04-29 16:08 ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>
  0 siblings, 2 replies; 13+ messages in thread

From: reda kodi @ 2020-04-24 20:58 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; security@postgresql.org <security@postgresql.org>

please i need this rpm for conto's 6
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat-repo-42.0-9.noarc...;

link doesn't work please help me when i instal new rpm i hav this problem


Erreur SQL :

ERROR:  column "spclocation" does not exist
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
                                                             ^

Dans l'instruction :

SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
                    (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
                                        FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname

^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: problem
  2020-04-24 20:58 problem reda kodi <kodi_reda@hotmail.com>
@ 2020-04-24 21:28 ` Bruce Momjian <bruce@momjian.us>
  2020-04-24 21:29   ` Re: problem Bruce Momjian <bruce@momjian.us>
  1 sibling, 1 reply; 13+ messages in thread

From: Bruce Momjian @ 2020-04-24 21:28 UTC (permalink / raw)
  To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

On Fri, Apr 24, 2020 at 08:58:44PM +0000, reda kodi wrote:
> please i need this rpm for conto's 6 
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/
> pgdg-redhat-repo-42.0-9.noarch.rpm;
> 
> link doesn't work please help me when i instal new rpm i hav this problem
> 
> 
> Erreur SQL :
> 
> ERROR:  column "spclocation" does not exist
> LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
>                                                              ^
> 
> Dans l'instruction :
> 
> SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
>                     (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
>                                         FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname

PG 12 had this change:

        Remove the <structfield>spclocation</structfield> field from <link
        linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>
        (Magnus Hagander)

I suggest you read all major release notes from your old PG version to
your new one.  You did not tell us what is generating this query.

Also, this has nothing to do with security, so you should post to only
one email list.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +





^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: problem
  2020-04-24 20:58 problem reda kodi <kodi_reda@hotmail.com>
  2020-04-24 21:28 ` Re: problem Bruce Momjian <bruce@momjian.us>
@ 2020-04-24 21:29   ` Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 13+ messages in thread

From: Bruce Momjian @ 2020-04-24 21:29 UTC (permalink / raw)
  To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

On Fri, Apr 24, 2020 at 05:28:05PM -0400, Bruce Momjian wrote:
> On Fri, Apr 24, 2020 at 08:58:44PM +0000, reda kodi wrote:
> > please i need this rpm for conto's 6 
> > https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/
> > pgdg-redhat-repo-42.0-9.noarch.rpm;
> > 
> > link doesn't work please help me when i instal new rpm i hav this problem
> > 
> > 
> > Erreur SQL :
> > 
> > ERROR:  column "spclocation" does not exist
> > LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
> >                                                              ^
> > 
> > Dans l'instruction :
> > 
> > SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
> >                     (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
> >                                         FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname
> 
> PG 12 had this change:

Sorry, PG 9.2 had this change:

> 
>         Remove the <structfield>spclocation</structfield> field from <link
>         linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>
>         (Magnus Hagander)

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +





^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: problem
  2020-04-24 20:58 problem reda kodi <kodi_reda@hotmail.com>
@ 2020-04-29 16:08 ` Alvaro Herrera <alvherre@2ndquadrant.com>
  2020-04-29 16:11   ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>
  1 sibling, 1 reply; 13+ messages in thread

From: Alvaro Herrera @ 2020-04-29 16:08 UTC (permalink / raw)
  To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; security@postgresql.org <security@postgresql.org>

On 2020-Apr-24, reda kodi wrote:

> please i need this rpm for conto's 6
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat-repo-42.0-9.noarc...;
> 
> link doesn't work please help me when i instal new rpm i hav this problem

Hello,

This address is for reporting security issues in PostgreSQL, not for
general support questions.

Please see https://www.postgresql.org/support/ and in particular the
pgsql-general mailing list for venues for general support questions.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: problem
  2020-04-24 20:58 problem reda kodi <kodi_reda@hotmail.com>
  2020-04-29 16:08 ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>
@ 2020-04-29 16:11   ` Alvaro Herrera <alvherre@2ndquadrant.com>
  0 siblings, 0 replies; 13+ messages in thread

From: Alvaro Herrera @ 2020-04-29 16:11 UTC (permalink / raw)
  To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

On 2020-Apr-29, Alvaro Herrera wrote:

> On 2020-Apr-24, reda kodi wrote:
> 
> > please i need this rpm for conto's 6
> > https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat-repo-42.0-9.noarc...;
> > 
> > link doesn't work please help me when i instal new rpm i hav this problem
> 
> Hello,
> 
> This address is for reporting security issues in PostgreSQL, not for
> general support questions.

Apologies, I forgot to remove the CC to pgsql-bugs.  The above was meant
to have the security@postgresql.org CC only.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





^ permalink  raw  reply  [nested|flat] 13+ messages in thread


end of thread, other threads:[~2020-04-29 16:11 UTC | newest]

Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-29 06:31 Problem Ram <ram@anantinfotech.com>
2002-07-02 19:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-09-11 07:37 Problem Prasanna <prasannaphatak@vsnl.net>
2002-09-16 15:12 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2004-05-14 08:17 problem Tomasz Lisica <tomaszl@zeto.olsztyn.pl>
2005-08-01 13:26 problem Vincenzo Montemurro <v.montemurro@convergere.com>
2008-04-22 22:19 problem Khobotko Oleg <oleg@1pr.ru>
2008-04-25 10:06 ` Re: problem Zdenek Kotala <Zdenek.Kotala@Sun.COM>
2020-04-24 20:58 problem reda kodi <kodi_reda@hotmail.com>
2020-04-24 21:28 ` Re: problem Bruce Momjian <bruce@momjian.us>
2020-04-24 21:29   ` Re: problem Bruce Momjian <bruce@momjian.us>
2020-04-29 16:08 ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>
2020-04-29 16:11   ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox