Re: [GENERAL] Re: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! (nearly fixed)

[Alban Hertroys]

On Aug 3, 2013, at 24:04, BladeOfLight16  wrote:

> My big concern as I've been reading this thread is whether users are cluster 
> specific or installation specific. If they're cluster specific, he'll need to 
> know credentials for his original cluster anyway to get the data, unless he 
> can do some kind of password reset.

They are cluster specific, as the roles are stored in the database. If you 
switch between different data directories, that means you're switching the 
available roles as well. And their details, such as passwords. You're also 
switching between configurations, such as pg_hba.conf.

Where it gets confusing a bit here is that there's usually also an OS postgres 
user, but that user is used to run the postgres server/service with limited 
credentials and not to log into the database. On Windows, apparently postgres 
is run under a standard network service account instead, which serves the same 
purpose.

Now, if you connect to the database without specifying a role-name to connect 
as, the standard tools (psql, pg_dump, etc. Don't know about pgAdmin) take your 
user account name and try to use that for the database login role, making it 
look like there's a relation between OS users and database users, but that's 
not actually the case (although there's an authentication option in pg_hba.conf 
to require such a relation).

At least, this is how I think it works. If I'm wrong someone will no doubt 
correct me ;)

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! (FIXED!!!)

[Stephen Brearley]

Right Chaps -think I've got a complete solution now...

 

All my bad habits seem to work, even if they are -er- bad, but between you,
you've just helped to complete the final part of the puzzle. BladeOfLight
gave a hint that I had a data installation on the C: drive, except I'm sure
I specified the D: drive. Anyway, the trouble-free install did indeed create
an empty \data folder on the C: drive. I think the install fix may either
have been something to do with the order in which I 'reset' things and moved
them around between installs, or the run of chkdsk (which may have solved
other non-Postgres issues!).

 

Anyway, the problem I had on the D: drive trying to move \data (the new
install) out the way, then re-name and substitute \data_old (my original
data) was because Windows would not let me fiddle with \data, as something
was using it. The missing info was following BladeOfLight's link here on the
PostgreSQl Wiki
  which mentions about stopping the Postgres service, an area of Windows
I had not needed to mess with before. By following these instructions, I was
able to make my data substitution, and 'Hey Presto', both Navicat and
pgAdmin allow me to see my original tables, which as BladeOfLight suggests,
are not prodigious, but it is the only copy I have of some data (without
having to wade through backups).

 

I note Alban's thoughts about minor upgrades, but I should probably do
regular pg_dumps.

 

Also, I put stuff on the D: drive as a separate partition on the same disk,
which won't protect me against all types of drive failures, but will protect
me from Windows crashes -which are far more common- and any necessary OS
re-install. I back up to an external drive, and use a dual-mirrored drive,
though there is stuff about two disks being bought at the same time likely
to die within a short time of one another. I'm intending a more
sophisticated system in the future, and think I will then have plenty of
space to set up a virtual Linux installation for stuff like Postgres, and
the wonderful QGIS/Grass etc. (not so good on the evil Windows).

 

Also, also, apologies for the top-posting. Yes, I am using the abomination
that is Outlook, but I will try to write shorter and clearer messages. I had
found a while ago, that I really liked Sea Monkey as an alternative client,
as I didn't realise my Office license allowed me an extra copy on my laptop.
However, I now link my PC to my phone, and the apps I have on there, only
offer Outlook as a client that they can link to, so I'm quite annoyed that
again I seem to be forced toward Microsoft. Ideally, I'd like to build my
own system which may not be so hard, but perhaps another (very) rainy day.. 

 

Many thanks again for everyones' help. Now more familiar with the friendly
folks out there, I shall now purchase a proper Postgres book(s), and curl up
with that for a bit.

 

  Stephen

[GENERAL] Exit code -1073741819

[Carlos Henrique Reimer]

Hi,

I have a Windows box running Windows Server 2003 Enterprise Edition Service
Pack 2 with PostgreSQL 8.2.23 and getting a server crash while trying to
select a table:

select * from "TOTALL.tt_est" where assina=' kdkd' ;

Dumping the table with pg_dump or creating indexes in this table produce
the same error.

2013-07-30 21:35:47 LOG:  server process (PID 2004) exited with exit code
-1073741819

2013-07-30 21:35:47 LOG:  terminating any other active server processes

2013-07-30 21:35:47 WARNING:  terminating connection because of crash of
another server process

Is this related with a hardware problem or some operational system issue?
Do a Windows reinstall or an windows upgrade fix the issue?

Thank you in advance!

-- 
Reimer

Re: [GENERAL] Installing 9.2 on Ubuntu from packages: what is the current recommendation?

[Sergey Konoplev]

On Fri, Aug 2, 2013 at 4:34 AM, Tim Bowden  wrote:
> Normally I install from source and create dummy packages as needed to
> satisfy dependencies, however I had an attack of the cbf's and decided
> to go looking for packages for Ubuntu 13.04 raring.  I discovered
> apt.postgresql.org only does LTS releases.  Is this the long term plan,
> or will intermediate releases also be supported in the future?
>
> Are packages for 13.04 being done by anyone? raring-backports doesn't
> have anything (yet?).

Here is the answer http://askubuntu.com/a/289388



>
> Thanks,
> Tim Bowden
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



-- 
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray...@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general